What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
No Answer is Posted For this Question
Be the First to Post Answer
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What is difference macros and prompts?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
What is powercenter on grid?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
what is row level and column level indicator?
What are the types of schemas we have in data warehouse and what are the difference between them?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is option by which we can run all the sessions in a batch simultaneously?