TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / pushparao
if there is no matching column two flat files, that means
two tables are different,no need to join the source
definitions in the designer.
there is possibility to join them.
create common columns in both expression transformations.
seqgen
|
sd-->sq-->expr
Joiner-->td
sd-->sq-->expr
|
seqgen
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
How do you set a varible in incremental aggregation
In informatics server which files are created during the session rums?
How can informatica be used for an organization?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to load a Dimension ? and how to load a fact table?
What is resilience time?
What is complex mapping?
What is a surrogate key?
How might one distinguish in the case of mapping is right or not without associating session?
How to extract sap data using informatica? What is abap? What are idocs?
Tell me about Propagate functions in informatica
How to update a particular record in target with out running whole workflow?
How to use procedural logic inside infromatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?