Scinario Based interview Question .....

 How To Achieve The Scenario.

Input

File1.csv 

id,Name

1,Mahendra

File2.csv

City, State

Hyd,Telangana

File3.csv

Stateid

Ts

I want Out put

File.Csv

Id,Name,City,State,StateId

1,Mahendra,Hyd,telangana,Ts

Solution:-

[tFileInputDelimited (File1)] --> [tAddRowNumber] -->|

                                                      |

[tFileInputDelimited (File2)] --> [tAddRowNumber] -->|--> [tMap] --> [tFileOutputDelimited (File.csv)]

                                                      |

[tFileInputDelimited (File3)] --> [tAddRowNumber] -->|

SQL very Important Questions :-

 SQL very Important Questions :-

--->--Find the Dupilcates From Table

SELECT JOB,COUNT(JOB) FROM EMP

 GROUP BY JOB

HAVING COUNT(JOB)>1;

---> Delete Duplicate From table

DELETE FROM  EMP E WHERE ROWID<> (SELECT MIN(ROWID) FROM EMP Y 

WHERE E.EMPNO=E.EMPNO);

-->dISPALY nTH SALARIES

SELECT * FROM(SELECT DENSE_RANK() OVER(ORDER BY SAL DESC)AS RNK,E.*FROM EMP E)

WHERE RNK=1;

Select * from emp where Rownum <= 5;

select rownum, e.* from emp e where rownum<=(select count(*)/2 from emp);

--->

select distinct A.empno, A.ename,a.sal,b.sal, A.mgr, B.empno, B.ename

from EMP A, EMP B where A.mgr = B.empno and A.sal > B.sal ;

very Important Questions :-

 SCR:- my source file data Coming Correctly yesterday , today some bad records Length is Exceed in my file without job fail process good records.. how to implement logic in Talend.

Example Job Flow:

1. tFileInputDelimited
   (Read your source file)

2. tSchemaComplianceCheck

   • Define your schema constraints:
     • Field Length: Set the maximum length for each column.
     • Data Type: Validate data types (e.g., String, Integer).
     • Nullability: Define whether null values are allowed.

3. Outputs from tSchemaComplianceCheck:

   • Valid Rows Output: Connect to your main processing components (e.g., database, transformation).
   • Rejected Rows Output: Save to a file using tFileOutputDelimited or log with tLogRow.

  Source File:-

City Having 3 Charter defined as per client requirement , But some one entry wrong data in source i want reject those records process remain records 

Job Desgin:-

Ouput

 Real Time interview questions:-

1.Write condition in tMap expression builder(i.e.,if the branch is CSE then computer science, IT then Information Technology, Other than CSE or IT then it is Other ) .

2. if we have 10 excel files which are in AWSs3 location how will you load the table in database oracle/postgres? IN this flow if the file is not correct how will you recect it?

3. We have 1crore records in input ,output should contains 10 files . Each file should have 10lakhs records.

4. Find count of columns in a file using Talend?

5.I have 3 jobs if job failed it should run from the point of failure?

6. I have 5 sub jobs, I want to run first 3 sub jobs parallel and other 2 sub jobs parallel how would you do it?

7. How we get first 100 records from a CSV file, last 100 records from a CSV file and how we get if we have actual header?

8. How to perform full outer join in Talend?

Answer Will Post as per comments