What are the tasks that can be performed using sq?
No Answer is Posted For this Question
Be the First to Post Answer
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
in oracle write query yourname+1 from dual
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
What is a node in Informatica?
how to through logic of informatica using the push down optimization into oracle.
As union transformation gives UNION ALL output, how you will get the UNION output?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
What is a rank transform?
Explain the types of transformations?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?