How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica
Answer / pavana
HI
In file properties set the optional quotes to either single
or double quotes. It considers the data b/w two Quotes as
the data for a single column .However the columns must be
separated by comma
Is This Answer Correct ? | 2 Yes | 1 No |
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
How to improve the performance of a session using sorter transformation?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the different lookup cache(s)?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Explain about the concept of mapping parameters and variables ?
What is a transaction control transformation?
What is informatica? Why do we need it?
what is the size of your data warehousing?
When the informatica server marks that a batch is failed?