How do you handle decimal places while importing a flatfile
into informatica?
Answer Posted / maruthi
1.)use to_integer('column name','newcolumn)
it works
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the features of complex mapping?
Differentiate between reusable transformation and mapplet.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Does an informatica transformation support only aggregate expressions?
Why update strategy and union transformations are active? Explain with examples.
What are the differences between joiner transformation and source qualifier transformation?
How can you differentiate between powercenter and power map?
What do mean by local and global repository?
Explain Dataware house architecture .how data flow from intial to end?
How can we use batches?
What is a rank transform?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Define sessions in informatica etl?
What is sq transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?