How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / raja
we use the union transformation,but metadata must be same
then it is possible to join the two hetrogenous tables
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is substr in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
As union transformation gives UNION ALL output, how you will get the UNION output?
How to partition the Session?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is an unconnected transformation?
What is rank transformation?
What are the guidelines to be followed while using union transformation?
Explain load alternative records / rows into multiple targets - informatica
What are session parameters ? How do you set them?
Explain the difference between mapping parameter and mapping variable?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can a transformation be made reusable?
what is the Default Source Option For Update Strategy Transformation?
How to do the error handling of if ur source is flatfiles?