Answer / ankit gupta

set commit interval as 100 in WF session and commitType as
target

Answer / srinivas

i believe this would certainly serve your purpose.

connect your source to filter transformation. if your
source contains p_key then the condition should be
p_key<=100. if it doesnt containa a primary key ex a flat
file create a new port in the filter transformation name it
s_no and connect the nextval port of seq.gen and the
condition shud be s_no<=100 and connect to the target.

Answer / sri

thank you for the answer, but I'm just wondering where to
write this code.
Could you let me know about the same.


Thanks,

Answer / jithendra

Hi,
In the session- goto Recovery strategy and then select 'Resume from last check point' it will run when the job failed at record after the next rerun it will run from the where it stopped.

Answer / naveen

Hi Ritu,

As per my knowledge there is no property to skip the rows
in source in case of relational table.

Please let me know if am wrong.

i would go with Answer #3 given by srinivas.

Regards,
Naveen

Answer / cutepa1

Is this what you wanna say that 101th observation has an
error in your dataset and you wanna save those
observations(until 100th) into the target dataset. If it so,
I've an idea I think it shld help a bit.

Data nn;/* your new dataset*/
set base.agents;
/* a dataset named 'agents' that has more than 100
observations*/
if _Error_=1 then output;
/* _error_ is a PDV variable that returns '0' when there is
any error in the code and returns '1' when there is no error */
run;

Answer / ritu sharma

go the source and there is a property of skip the number of
rows.set it to 1 and then save the mapping and run the workflow.
Ritu Sharma

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

Explain the etl program with few examples.

0 Answers  

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

When will you use SQL override in a lookup transformation?

1 Answers  

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers