how to join two flat file if they have diff. structure?how to join one relational and one flat file?




Answers were Sorted based on User's Feedback



how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / sravanthi

using joiner tranformation to add two diff structure of flat files...

Is This Answer Correct ?    7 Yes 2 No

how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / pradosh

if the flat files has diff stracture then
sd-->sq-->exp>
...>join-->tgt
sd1-->sq1-->exp1>

that means take flat file source then take 2 exp transformation in which u take variabl ports i.e a=1 and exp1 is b=1 then based on condition u take a joined trans and connect to target.

join takes diferent sources

Is This Answer Correct ?    4 Yes 0 No

how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / vijay

you have two flat-files with u.
prepare two source instances with the structure you have as
oracle relational tables. after that change them to
flatfiles in the source instances.
then connect to the target's that u already prepared by
simple-pass mapping. now you have two relational source
tables with u,then join the tables using joiner.
--------------------------------------------------
how to join one relational and one flat file?
same as above convert the flatfile to relational table
through simple-pass mapping. now join two relational tables
using joiner in the same mapping itself.

Is This Answer Correct ?    0 Yes 0 No




how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / mehul thakur

Hi sravanti
Could U please explain how to join ?

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Informatica Interview Questions

where is the reject loader .

1 Answers  


what is the difference between onsite & client site?

1 Answers  


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,


If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  






What are the mapping parameters and mapping variables?

0 Answers   Informatica,


Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,


What is a command that used to run a batch?

2 Answers  


What are the methods for creating reusable transforamtions?

2 Answers  


.prm wirh repalce .txt is possible?

2 Answers  


How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,


Does Facttable Normalized or Denormalized?

2 Answers   IBM,






Categories