Interested to Buy Any Domain ? << Click Here >> for more details...
What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
- 8 Answers
- 25287 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / deepu
To load 5 differnt files of same format .first creat a
directory in Unix and copy all the file into this directory
and using the option as Indirect load in session properties
give the loaction of unix in source and it will enable to
load all the 5 files in single run in to a target . if we
have 5 diff files in 5 different formats then firstly
convert all in to one format and then proceed as explained
aboue.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
write a query to retrieve the latest records from the table sorted by version(scd)
Explain pushdown optimization and types in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Under what condition selecting sorted input in aggregator may fail the session?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Write the unconnected lookup syntax?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are batches?
How do you convert single row from source into three rows into target?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is Active lock explain
waht type of interface is used for testing the data in informatica
Mention few advantages of router transformation over filter transformation.
