1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task

Question Posted / raghu

Answers were Sorted based on User's Feedback



i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / suresh

hi rachana

if here there are 100 tables
at that time we have to use 99 joins or is there any
another process for joining the 100 tables from diff
sources into to a single target

let me know if u know the answer

thanks for u r considiration

Is This Answer Correct ?    1 Yes 2 No

i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / rachana

Use a Joiner Transformation to join the tables and load
into single target. Joiner tarnsformation can join
heterogenous sources

Is This Answer Correct ?    0 Yes 3 No

i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / manish

we can use different target object for the same target table
and can load the data

Is This Answer Correct ?    1 Yes 4 No

i have different sources in different databases ,that sources may be 100 tables i want to load th..

Answer / gopi krishna k

write a pre sql which joins all 100 tables
Am I right?

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is a parameter When and where do you them when does the value will be created

0 Answers  

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

which transformation uses cache?

3 Answers   Keane India Ltd,




What is a command that used to run a batch?

4 Answers  

What happens if we dont select data driven option?

2 Answers   Zensar,

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

What are the types of data warehouses?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories