How do you handle decimal places while importing a flatfile
into informatica?
Answer / maruthi
1.)use to_integer('column name','newcolumn)
it works
| Is This Answer Correct ? | 6 Yes | 4 No |
tell me the informatica architecture
What is target load order?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
Describe two levels in which update strategy transformation sets?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
normalizer transformation
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Explain about cumulative Sum or moving sum?
Explain what is informatica metadata and where is it stored?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records