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?
Answer Posted / 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 View All Answers
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What the difference between “look-up” file and “look is up” in abinitio?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
List out some of the air commands used in abintio?
What are the fundamental blocks of co> operating system of ab initio?
Can anyone give me an exaple of realtime start script in the graph?
What does edp stand for?
What are the differences between different versions of co-op?
What is the purpose of having stored procedures in a data-based?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What is is a data flow graph?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Define ramp limit in ab initio?
What would be the next step after collecting the data?