what is the main advantage of unconnected lookup
Answers were Sorted based on User's Feedback
Answer / praveen sh
If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence
| Is This Answer Correct ? | 15 Yes | 0 No |
How to start a workflow using pmcmd command?
who is the best faculty for informatica in hyderabad ameerpet?
Explain Dataware house architecture .how data flow from intial to end?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
How do you load only null records into target?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
In which scenario did u used Mapping variable?
How we can confirm all mappings in the repository simultaneously?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.