In CSV flat file date are in the following format.
dd/mm/yyyy (05/01/2005)and
d/m/yyyy (5/1/2005) and
dd/m/yyyy (05/1/2005) and
d/mm/yyyy (5/01/2005). It should be load to target
in a unique format. How will you implement this?
Answer / davankumar
To_char(date,formatedate) in the expression t/r
| Is This Answer Correct ? | 3 Yes | 0 No |
Is it possible to create multiple domains on a single Informatica server?
Briefly define a session task?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
if i am having 10 records in source, i want 20 records in target...how will you do it
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is fact and what types of fact tables is there
Explain informatica architecture - version 8 / 9
Can any one explain or sujjest some sites for scd mappings.Thank you
I want skip first 5 rows to load in to target? what will be the logic at session level ??