After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?
Answer Posted / veeru
No,
By joining the three sources, we can load in to the target
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
How are the sources and targets definitions imported in informatica designer?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to open an older version of an object in the workspace?
What are the reusable transformations?
what is size of u r database?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What can we do to improve the performance of informatica aggregator transformation?
Which is the t/r that builts only single cache memory?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are batches?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Under which circumstances, informatica server creates reject files?
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,
Whats there in global repository