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
Explain the features of connected and unconnected lookup.
tell me the rules and responsblites in our project(my project is development)
What is exclusive and normal mode for repository services?
How to use procedural logic inside infromatica?
how many types of dimensions are available in informatica?
How to differentiate between the active and passive transformations?
What are the issues you have faced in your project? How did you overcome those issues?
Explain the informatica workflow?
Explain what transformation and how many are there in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain incremental aggregation in informatica
Separate from an archive server and a powerhouse?
Is it possible to define a single node as a Gateway node as well as worker node?
Write the unconnected lookup syntax?
How to update source definition?
