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
Which files are created during the session rums by informatics server?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the different transaction levels available in transaction control transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How is union transformation utilized?
What are the types of schemas we have in data warehouse.
How can we create index after completion of load process?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you take back up of repository?
What is a rank transform?
Informatica Checkpoints
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
what is mean by complex business rule ?
Which transformation should we use to normalise the COBOL and relational sources?
Tell me about MD5 functions in informatica