Interested to Buy Any Domain ? << Click Here >> for more details...
-
Teradata (490) - Business Objects (875)
- Cognos (1143)
- Informatica (2428)
- Crystal Enterprise Suite (30)
- Actuate (46)
- Ab Initio (442)
- Data Stage (917)
- SAS (1049)
- Micro Strategy (282)
- ETL (315)
- OBIEE (92)
- IBM Cognos TM1 (55)
- Amazon Redshift (62)
- Data Warehouse General (749)
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
2 5126how to design mapping half of source table records into one target and remaining half into another target
ABC,
8 15345there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
4 6936performance wise which one is better in joiner and lookup transformation?why?explain clearly?
IBM,
4 21453There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
IBM,
7 12694My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
3 9527How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
1 7094I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
IBM,
1 4758Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
IBM,
3 8848Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
IBM,
2121In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
IBM,
2 7769there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
3 6487
How to generate iqd file from framework manager?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
how do u set partition points in the mapping?
What are the supported languages for microstrategy intelligence server?
what is dynamic insert?
Write the unconnected lookup syntax?
hi friends pls forward impropmtu interview question
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
How to select first n records in teradata?
How do you load unique records into one target table and duplicate records into a different target table?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What are different types of joins that are possible in obiee rpd?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
