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 |
tell me the push down optimization
how to declare array in plsql?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What is CDC? How to implement CDC?
When do you use mapping parameters? (In which transformations)
What are the settings that you use to configure the joiner transformation?
How does the server recognize the source and target databases. Elaborate on this.
How do you update the records with or without using update strategy?
How will you update the row without using update statergy?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
How are indexes created after completing the load process?