On which Dimension Table you implemented SCD Type in your
Project
No Answer is Posted For this Question
Be the First to Post Answer
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
how CAN we remove duplicates in dataset?
how to handle null values using transformer stage?
source contains 2 columns comes to target 4 columns how
If you want to use the same piece of code in different jobs, how will you achieve it?
why dataset ?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.