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
What is rank transformation in informatica
State the differences between sql override and lookup override?
What is the use of transformation?
What is the meaning of up gradation of repository?
What is option by which we can run all the sessions in a batch simultaneously?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
define galaxy repository in informatica
Explain dynamic target flat file name generation in informatica
What are batches?
How identifying bottlenecks in various components of informatica and resolving them?
Explain joiner transformation in informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
design of staging area?
What is the procedure for creating independent data marts from informatica 7.1?
Where are the source flat files kept before running the session?