without matching columns in two tables. how can you join
Answer Posted / sivaraj c
Use indirect Load through reference file which holds the file name of both source files.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Briefly describe lookup transformation?
How do you set a varible in incremental aggregation
Different sorts of metadata that stores in the storage facility?
What is the difference between STOP and ABORT options in Workflow Monitor?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is Session and Batches?
Which transformation should we use to normalise the COBOL and relational sources?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what are the deliverables?in your project?
How might one distinguish in the case of mapping is right or not without associating session?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Differentiate between joiner and lookup transformation?