Interested to Buy Any Domain ? << Click Here >> for more details...
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 19467 Views
- HP, TCS, I also Faced
- E-Mail Answers
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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is a connected transformation?
Define update strategy?
Explain about cumulative Sum or moving sum?
What are the different versions of informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the mapping parameters and mapping variables?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are junk dimensions?
What is meant by pre and post session shell command?
What is exclusive and normal mode for repository services?
What is the difference between STOP and ABORT options in Workflow Monitor?
