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 / rahul
no its not possible.
sql trans is used to connect hetro src but when you drag
flat file n connect to Sq t/r , all properties expect
tracing level evey thing will be disable.
SO WE CANT JOIN
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why is sorter an active transformation?
What are the settings that you use to configure the joiner transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What is lookup transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Sequence generator, when you move from develoment to production how will you reset
Which development components of informatica have the highest usage?
What is meant by a domain?
Explain sessions?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the measure objects?
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 generate sequence numbers without using the sequence generator transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain pmcmd command usage in informatica