What are the Tracking levels in Informatica transformations? Which one is efficient and which one faster, and which one is best in Informatica Power Center 8.1/8.5?
Latest Answer: Also for efficient & faster depends on your requirement.If you want minimum information to be written to the session logs you can use the Terse tracing level.From Informatica Transformation Guide:"To add a slight performance boost, you can ...
Explain Why it is bad practice to place a Transaction Control transformation upstream from a SQL transformation?
Latest Answer: SQL Transformation drops any incoming transaction boundaries ...
Why the input pipe lines to the joiner should not contain an update strategy transformation?
Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?
Latest Answer: A transformation is called active if it varries the number of rows passing through it, just say total incoming rows=1000 and total outgoing rows < or > 1000.in case of router transformation count of total output rows in all the routing groups is ...
In which situation do we use update strategy?
Latest Answer: Update Strategy is an active and connected. Generally we use update strategy before target. To Insert or update or delete or reject rows coming from the source to target. The constants we use in update strategy transfromation are:DD_INSERTÂ OR 0 --> ...
In which situation do we use unconnected lookup?
Latest Answer: The advantage of using an Unconnected Lookup is that the Lookup will be executed only when a certain condition is met and therefore improve the performance of your mapping. If the majority of your records will meet the condition, then an unconnected ...
What are the possible dependency problems while running session?
Latest Answer: Dependency problems means when we run a process, the process output is input to other process. Then first process is stopped then it causes problem or stop running other process. One process is depending on other other. If one process get effected then ...
How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?
Latest Answer: Bad files contains column indicator and row indicator.Row indicator: It generally happens when working with update strategy transformation. The writer/target rejects the rows going to the targetColumnindicator:D -valido - overflown - nullt - truncateWhen ...
How & Where will you can see data loading in targets dynamically?
Latest Answer: We can check the target recorded loaded dynamically by validating the query on target records with time period.1) We need to run the target records related query for first load with time period and find the record count of data, any duplicate records ...
What happens if you turn off version?
Latest Answer: You would not be able to track the changes done to the respective mappings/sessions/workflows. ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
