TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 18694 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
What is meant by pre and post session shell command?
Whats there in global repository
Explain incremental aggregation in informatica
What does reusable transformation mean?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain your project of banking domian.
Performance tuning in UNIX for informatica mappings?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to delete duplicate row using informatica?
What is enterprise data warehousing?
What is the difference between router and filter?
In informatics server which files are created during the session rums?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are mapplets? How is it different from a Reusable Transformation?
