Answer / sunil

Use the replace function in expression and replace',' as null

REPLACE(1,sal,',null)..
It should work

Answer / hardik

We can simple concatenate 3rd and 4th Row i.e 1 and 000 and
put that concatenated output port in target.

Answer / varun s

OPEN THE SOURCE FILE-->EDIT-->REPLACE ALL , to NULL.
USE FIXED WITH LENGTH WHILE IMPORTING TO SOURCE AND .....
HOPE IT WILL HELP

Answer / magnil

how would it be possible if value is other than ,000?

Answer / ramkrishna

open the original source flat file then from edit menu
select replace then enter values as find(,000) and replace
with (000)
then save the source file with other name then continue the
process as the flatfile

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

what are the limitation of sorter transformation?

2 Answers   TCS,

Can you copy the session to a different folder or repository?

2 Answers  

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

What happens if we dont select data driven option?

2 Answers   Zensar,

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

Why do you use Mapping Parameter and mapping variable?

0 Answers