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
Answers were Sorted based on User's Feedback
Answer / 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 |
What is status code?
What are data-driven sessions?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
What is operational data source (ODS)?
Explain constraint based loading in informatica
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What is the difference between IN and Exists in Oracle?
how to work with mapplet designer in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
Explain about HLD and LLD ?