input ------------- name | no -------------------- Bose 1 Mani 2 Arun 3 Output ------------- name | no -------------------- Bose 1 Mani 2 Mani 2 Arun 3 Arun 3 Arun 3 to get the Using transformer stage help me ASAP

Sandy

• Feb 15th, 2018

Tx => Functins=>string=>str(iput.name ,no)

muni

• Dec 20th, 2017

Using normalize component
in that transform < length(in.no) >
and assign drop to drag input to output

Answer Question  Select Best Answer

I am having input--> I want Output like--> slno|Name slno|Name 1|X 1|X 2|Y 2|X 3|Z 2|X ...

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Sep 12th, 2017

Considering the input data is below. slno|Name 1|X 2|Y 3|Z desired output is slno|Name slno|Name 1|X 1|X 2|Y 2|Y 3|Z 3|Z In the transformer output link add a new column called Na...

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Apr 18th, 2017

Considering the input data is below. slno|Name 1|X 2|Y 3|Z desired output is slno|Name slno|Name 1|X 1|X 2|Y 2|X 3|Z 2|X In the transformer output link add a new column called Name_slno...

Answer Question  Select Best Answer

I have one scenario below, how can we achieve. City1,City2,Distance ============== blr, pune,1000 km pune, blr, 1000 km As we have same data in 2 records but need to delete any one of the duplicate record.

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Aug 8th, 2017

Job Design : Sequential file(I/p) --> Transformer --> Sequential file (o/p) In the Transformer stage , define 2 stage varibles st1 and st2. Derivation for st1 => If city2:city1=st2 Then 1 Else 0 ...

siva krishna

• Jun 16th, 2017

Hi, Ive solved this as mentioned below. seq stage (source)----->sort stage ------> transformer stage -----> remove dupli stage ---->seq stage(target) read the source and add FILENAME COLUMN column...

Answer Question  Select Best Answer

I have an input file in the below format : NAME SAL ---- --- A 4000 B 3000 C 8000 A 2000 B 7000 C 5000 B 2000 C 9000 A 1000 If I will use Sort ---> Aggregator Group by then it will give 3 columns like NAME,MAX(),MIN() NAME MAX() MIN() ---- ----- ----- A 4000 1000 But my requirement is to generate the output which will give the maximum & minimum salary...

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Apr 18th, 2017

Job Design : Sequential File --> Aggregator --> Transformer --> Sequential File Aggregator : Group by - EmpName Col for Calculation - Salary Generate two columns - one for maximum salary (Max()...

Neha

• Apr 7th, 2017

Use Seq File->Aggregator Stage (group by Salary, Emp_Name and find min, max salary)->use Pivot(horizontal Pivot)

Answer Question  Select Best Answer

I have the 10 input file like F1,F2...F10 then I need to load these 10 input files into 10 target Output tables like T1,T2...T10. Here is the scenario for 10 tables But in future If i will receive 100 input files then I need to load it into respective 100 target tables. After loading the input files into target tables I need a confirmation in the respective target tables(By input File name) Please...

Reddy

• Jun 28th, 2017

This can be achieved by creating multiple instance job and parameterizing the source file name, table name and also need to enable run time column propagation.

shasank

• Apr 24th, 2017

We can do that allowing multiple instances for a single job in the job properties tab.

Answer Question  Select Best Answer

Source have phone number with 8 digit and target has 10 digit. How to test target phone number has 10 digit start from +91?

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 30th, 2017

First Thing: If phone_num is type numeric, + is not allowed. Second Thing: If phone_num is varchar, and the length of the phone_num is 8 in source, if you want +91 to be appended in the beginning the ...

Naushad

• May 17th, 2016

Code
SELECT t.phoneno FROM target t, source s WHERE substring(t.phoneno,0,4)=+91
AND +91||s.phoneno=T.phoneno

Answer Question  Select Best Answer

How to select the Even and Odd records in SQL server and in Oracle without using ROWNUM,ROWID

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 30th, 2017

"oracle8 TO SELCT EVEN RECORDS IN ORACLE : ----------------------------------------------- SELECT CUSTOMERID FROM (SELECT CUSTIMERID, CASE WHEN MOD(CUSTOMERID,2)=0 THEN EVE...

MUKUL MALIK

• Aug 22nd, 2016

SELECT customerid,case when customerID %2=0 then even
when customerID %2 < > 0 then odd end as result from customers

Answer Question  Select Best Answer

Any One please explain me roles and resposibilities of ETL testers as well as explain me his work from starting point to end point in ETL testing Thanks..

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 25th, 2017

As an ETL Tester you need to know - What is the purpose of the ETL jobs that you are testing(whether you are loading data into the table or writing data into intermediate files which will be loaded l...

Deepti

• Jan 5th, 2017

ETL Testing Process Steps 1. Understand the end to end design. 2. Test Plan Preparation. 3. Test Scenario Preparation (optional) 4. Preparing the test queries to perform the following validations: &nb...

Answer Question  Select Best Answer

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Prashant

• Nov 25th, 2018

If your output file is sequential file then you can you use filter property .

Prashant

• Nov 25th, 2018

If the input has 2 partion then i would get 2 rows for lastrow() function. rest everyhing is correct

Answer Question  Select Best Answer

Rajesh

• Aug 22nd, 2022

ODS is mainly used to integrate the data of different Sources having same functionality of the data into one integrated model. This model is mostly denormalized and will not be useful for reporting. E...

Ankush

• May 18th, 2017

You mentioned ODS comes after staging area is not true i guess. Flow is like ODS->staging->DWH as per my knowledge. Kindly correct me if wrong.

Answer Question  Select Best Answer