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


Please Help Members By Posting Answers For Below Questions

How does a sorter cache works?

582


How to generate or load values in to the target table based on a column value using informatica etl tool.

619


hi real timers . iam waiting for ur reply regarding ETL TESTING

1818


tell me 5 session failure in real time how can you solve that in your project?

1642


What do you mean by channel change?

558






How are indexes created after completing the load process?

1000


Define Pmrep command?

646


What does refresh system mean, and what are its distinctive choice?

580


r u done any partitions in ur project?

1414


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

819


What are the different lookup cache(s)?

630


Which version configuration tool used in ur project?

2781


How to create a non-reusable instance of reusable transformations?

694


Tell me about MD5 functions in informatica

532


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1657