if i have a delimited file as source so how can we seperate this file into three diff targets?
Answers were Sorted based on User's Feedback
Answer / lakshmi
using expression ,transaction control transformations
| Is This Answer Correct ? | 0 Yes | 0 No |
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
What is blocking transformation?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
if i have a delimited file as source so how can we seperate this file into three diff targets?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
task is running successfully but data is not loded why?
How do you use reject loader.
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
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,
can we create index and drop index in exsisting table while using infomatica