Answer Posted / venkateshmalneni
If the structure of the two flat files is same we can use SQ.by using in direct
if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this
src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
draw informatica architecture 8.6 ?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to handle decimal places while importing a flatfile into informatica?
During the running session, output files are created by informatica server. Enlist few of them.
What is the commit type if you have a transaction control transformation in the mapping?
What is a node in Informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
explain abt ur project architecture?
In informatics server which files are created during the session rums?
difference between informatica 8.1.1 and 8.6
Explain direct and indirect flat file loading (source file type) - informatica
What is informatica?
What is domain in terms of informatica?
How to create or import flat file definition in to the warehouse designer?
Mention a few design and development best practices for informatica?