1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category

I had 10,000 records r there i loded today 4000 records, i
need load to 4001 - 10,000 next day how is in Type 1 and
how is it on type 2?

Question Posted / veluruabinitio

Answers were Sorted based on User's Feedback



I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how..

Answer / ss

simply take a reformat component and then put
next_in_sequence()> 4000 in select parameter.

Is This Answer Correct ?    21 Yes 2 No

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how..

Answer / pappu

First, The interviewer is !! He shud ask question which is relevant to project and scenario, which he doesn't have any idea.

Is This Answer Correct ?    6 Yes 2 No

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how..

Answer / mahendra patnaik

Take 10,000 records as source file and take output table as
another source and then Join both the source,select input
must be sorted parameter option in the Join component,If
any matching records found then put that into a thrash,
take all unmatched records and inert into the target table.

Is This Answer Correct ?    3 Yes 2 No

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how..

Answer / amansharma3737@gmail.com

Hii
Question is correct.
In case of type one.. Record will be there in database but history won't be present.
In case of type two.. record and history both will be available( we can use effective date to get the history )

Is This Answer Correct ?    0 Yes 0 No

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how..

Answer / eswer

hi pappu...it is the correct question ly.He touchess about
SCD TYPE1 and SCD Type2 which plays an very importent role
in desining of tables

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Ab Initio Interview Questions

In Join component which record will go to unused port and which will go to reject port ?

3 Answers   JPMorgan Chase,

What is brodcasting and replicate?

1 Answers  

Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

1 Answers  

How to implement the funtionality in the custom component to use in the graph?

1 Answers  

. What is flow buffering ? How it reduces the chances of having deadlock ?

1 Answers   HCL,

What is the function you would use to transfer a string into a decimal?

1 Answers  

If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?

4 Answers   IBM,

What does it mean by the term 'sort component'?

1 Answers  

Can we specify checkpoints without Phases?

3 Answers   IBM, Tech Mahindra,

Explain the ab initio etl tool in high level?

1 Answers  

What are the types of data processing you are familiar with?

1 Answers  

Describe how you would monitor and control database physical file size and growth?

3 Answers   IBM, Satyam,

For more Ab Initio Interview Questions Click Here
Categories