what is diff between IN and EXIT commands
Answer / kamesh
IN: Where they r 2 tables dept and emp the records which r
matched records present in both the table will displayed.
EXIT:the all records are displayed including the records
which are matched.
Is This Answer Correct ? | 6 Yes | 0 No |
If a table contains 100 records we have to fetch 50-100 records from source to target?how
How to load duplicate records in to a target table which has a primary key?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
one source to target loading insert new rows and update existing rows?
can we use bulk loading when we use look in mapping
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
can we use self join in informaitca?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
with out using update strategy transnsformation how to update the data in mapping level
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?