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



I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal ..

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

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal ..

Answer / davankumar

to_char(10000,'99,999.00') from dual;

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is status code?

2 Answers  


What are data-driven sessions?

0 Answers  


Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  


What is operational data source (ODS)?

7 Answers  


Explain constraint based loading in informatica

0 Answers   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/

4 Answers  


What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,


how to work with mapplet designer in informatica?

7 Answers  


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


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.

4 Answers   Cap Gemini, IBM,


Explain about HLD and LLD ?

16 Answers   Accenture,


Categories