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 |
When will you use SQL override in a lookup transformation?
What are variable ports and list two situations when they can be used?
How can we get two output ports in un-connect transformation?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
How do you remove duplicate records in informatica?
How we can use union transformation?
What is the difference between a shortcut of an object and copy of an object? Compare them.
How can you run a session without using server manager?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
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 are roles and groups and benefits of using them?
What are the connected or unconnected transforamations?