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 |
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
where to store informatica rejected data? How to extract the informatica rejected data?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
what is datamart
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
How many mapplets u have created? and what is the logic used
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What are the diffrences between joiner transformation and source qualifier transformation?