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?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
how remove 1st 3 records & last 3 records in informatics
What is difference macros and prompts?
How to recover the standalone session?
how to we create datamart?
how do u fnd the duplicate rows and how to delete the duplicate rows?
scenario where i can use only concurrent execution of workflow.
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
How do we implement materialized view?when to use materialized view?
How to send duplicates to one target and unique rows to one target?target is empty
What is the command used to run a batch?