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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the meaning of up gradation of repository?
What is the benefit of partitioning a session?
What are the transformations that are not supported in mapplet?
What is a mapplet/worklet in informatica?
What is the difference between informatica 7.0 and 8.0?
r u done any partitions in ur project?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Scheduling properties,whats the default (sequential)
Explain incremental aggregation in informatica
How to create or import flat file definition in to the warehouse designer?
Is there any way to read the ms excel datas directly into informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a code page?
The question was on time stamp. what is the difference between HH and HH24 when to use when.