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

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

Question Posted / chandranmca2007

2 Answers
9217 Views
DELL, iGate, I also Faced
E-Mail Answers

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

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers

Normalizer transformation is not involved in Mapplet.. why???

1 Answers Wipro,

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers TCS,

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers Cap Gemini,

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers CTS,

What is the function of union transformation?

0 Answers

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers Accenture,

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers Deloitte,

why we r using presql&postsql in source qualifier?

1 Answers HP,

How are the sources and targets definitions imported in informatica designer?

0 Answers Informatica,

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers Zensar,

In a sequential batch can you run the session if previous session fails?

4 Answers

For more Informatica Interview Questions Click Here