Interested to Buy Any Domain ? << Click Here >> for more details...
how to import multiple flat files in to single target where
there is no common column in the flat files
- 2 Answers
- 7415 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramana sreepathi
in workflow session properties in Mapping tab
in properties
choose Source filetype Indirect
Give the Source filename : <file_path>
This <file_path> file should contain all the multiple files
which you want to Load
| Is This Answer Correct ? | 9 Yes | 2 No |
Why touse stored procedure in ETL Application?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain Dataware house architecture .how data flow from intial to end?
What is use of batch file in informatica? How many types of batch file in informatica?
What are the challenges of Dataware housing in the future?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
Can we create two repositories on same database instance in oracle?
what r the transformations that r not involved in mapplet?
How many ways are there to do 'remove duplicate records in informatica'?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What is informatica? What exactly are the practical uses in real world
Teradata 
