What is the surrogate key?
No Answer is Posted For this Question
Be the First to Post Answer
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
Briefly define a session task?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is domain and gateway node?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
State the limitations where we cannot use joiner in the mapping pipeline?
Can you generate sequence numbers without using the sequence generator transformation?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
Can we use parameters of parameter file in presession command
What are the different clients of powercenter?