I have Flat file like the data, sal have 10,000. I want to
load the data in the same format as sal as 10,000. Can
anybody know the answer means please mail me.
Thanks in advance.. My mail id is chandranmca2007@gmail.com
Answer Posted / sagarreddy
HI,
in target table options we have thousand separator,hundred
separator ,.................other options also available
.............
check it plz go through it .................
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
What is flashback table ? Advance thanks
What are the guidelines to be followed while using union transformation?
Tell me about Propagate functions in informatica
How to load data in informatica ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain what transformation and how many are there in informatica?
How we can use union transformation?
What are data-driven sessions?
Mention few power centre client applications with their basic purpose?
What is a dimensional model?
What is an aggregator transformation?
how to load rows into fact table in data warehouse
What does role playing dimension mean?
Why do you use Mapping Parameter and mapping variable?