 Suppose you have n no.of records @ your flat file and you
have seen some of records are missing while reaching to the
destination. How can you trouble shoot it?
Answers were Sorted based on User's Feedback
Answer / vikram
While populating to target rejected loads will be loaded in
to bad files and we can cross check the data there and the
other way is run the load in verbose mode to check the
exact reason this happens when the flat file data is not in
correct format.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sarat
The above method tells us how many are missing, after that take the TARGET as Dynamic LKP and update the target for All rows to be loaded
Is This Answer Correct ? | 0 Yes | 0 No |
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
How to go to the older version for a mapping?
hw cn v elimate dublicate values from lookup without overriding sql?
What is router transformation
How do you join more than 3 flat files in informatica?
What is an active transformation?
what is size of u r database?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
 Informatica Checkpoints
Insert else update option in which situation we will use
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this