วีดีโอ

In real time by any chance we use these replication & synchronization tasks Bro? just for interview purpose asking..!

thanks helped a lot :)

Hi sir Could you please help me to migrate job from datastage to iics

Can’t we connect source to targets directly and map the fields accordingly? Are aggregator and expression really needed?

Hi, can I have your contact number I have few questions regarding interview preparation?

if first task completed first some parallel raska nd some linear things will run ..while another branch runs ..so have to set up some condition

Tell me the approach for below scenario:you have 5 files in that 4 is having same structure and 1 is having diff structure then how to load 5 files to target within a one mapping.

could you explain difference b/w joiner and lookup which one is give best performance .and why?

There is no consistency in audio

Not working for SQL Server Procedure

Nicely elaborated , helped my task....

Are we getting calls on iics

Thank you so much it helped me a lot

R we getting calls on iics?

Bro...atleast are u able to see the video properly....plz fix on this some people using best video quality

Hi how to select for excel file read from the 6 th line

hello bro make videos on each and all the transformations available in iics.

pls explian all

HARMAN COMANY== --------------- 51.How do you integrate CDQ Component in CDI Dataflow? 52.What to create a generic mapping, the target is always Drop and Replace, Source is a flat file but i dont know the structure of it My challenge is to create a dynamic mapping, so that it will detect any kind of flat file, and process to the target table at create table at runtime, today i get comma, tomorow i may get pipe delimiter and so on. how can i implement this senario. 53. What is Md5 Function 54. How will you handle Nullability while using MD5 function, if there are 10 columns are null, in the incoming 15 columns how do you handle it. 55. Alternative of md5 function in informatica powercenter (CRC32) 56. What is the difference between FTP and SFTP 57. How do you ingest data into Snowflake 58.I have taskflow with multiple tasks like datatask, notification task, command task and many more how to parameterisie this completely i want to assign taks flow level parameters values dynamically, how can we achive this. 59.What the struturee of the parameter file if we have input connectin, data objects, expression variables for smooth execution of the mapping 60. What are the window functions available in Oracle or in advance 61. Senario EMP no name Dep_Name Salary 1 raj IT 100000 Output: Emp Pivot 1 raj IT 10000 HARMAN L2 ROUND ----- ---------- 1)How to delete duplicates in Snowflake 2)AWS S3 Bucket i have load to one of the snowflake stage table how can we do it? 3) Do you know what is the differnece between Parameter Set and Parameter File. 4) When you concate 2 columns and 1 column has null what will be the output result. 5) What is the difference between the Input fields and temp fields 6)10 Source Files data from each location we are getting they are having different department, we dont know how many departments are there how can we create flat files as targert for each department 7)IICS Taskflow how are you scheduling the Taskflows, are you using any external tool 8)How can we add dependancies b/w 2 different taskflows in IICS and how can we schedule it. ---------------------------------------------------------------------------------------------------------------------------------------------- INFOSYS -------- -------- 70.How do you load Jason file in IICS 71. What is analytical functions in database 72.What is the advantage of using expresssion over aggregator 73.When you concate 2 columns and 1 column has null what will be the output result. 74.Can we use DML operations without using Update Strategy 75.There are 4 sessions under 1 workflow in a sequential manner, 1st mapping gives a value how to use this value in 2nd mapping. ------------------------------------------------------------------------------------------------------------------------------------------ LEGATO HEALTH COMPANY --- -------------------- 76.have you used data profiling 77.100 different files coming in every day how do you load to Target 78. 100 different files every day how to create files dynamically at run time scenario Input 1 1000 2 2000 3 3000 4 4000 5 5000 Output 1 2. 3. 4. 5 1000 2000 3000 4000 5000 ---- scenario join table count Inner Left Right Outer 9) scenario - output for row_nunber, rank and dense rank Input A 1 1 2 3 4 5 6 10)scenario IND Aus Pak Eng Required Output IND Aus IND Pak IND eng Aus Pak Aus eng Pak eng 11)select * from table_name Where true - what is the output of this query 12) What is snowflake stages 13) What are the file formats available in Snoflake, 14) What is zero copy cloning 15) Join Scenario, tell the output for all the Joins A B 1 1 1 1 1 Null Null 0 --------------------------------------------------------------------------------------------------------------------------------- MASS MUTUAL COMPANY 81.If two records ar matcing in the look up what will be the output ? 82.When we use update strategy what are the session level properties we need to set in session properties. 83. What is Pivot & Unpivot function? 84.What is difference between group functions and scalar functions? 85.Can we send mapping variable of one mapping to another mapping? 86.When you doing the mapping what type of errors we got tell me some errors? 87.Between lookup & joiner which is better? ---------------------------------------------------------------------------------------------------------------------------------------------------- TRIANZ COMPANY -- --------- 88.If your asked to suggest to the clinet which design you will suggest top down or bottom up and why? 89.Do you see any challenges if you go by Top-Down Approach? 90.What do you mean by normalised data? 91.How do we ensure that the data is normalised? Any rules which we need to implement or its just a thought process. 92.Let us say IICS mapping is not running on time as expected how do you troubleshoot the mapping. SQL Questions 1)How do you tune the SQL part, lets say if you have sql query and its taking much time to run, how do you tune it. are there any guidlines 2)We have a state table and an employee table, we need the count of employees for all the states. 3)Have you worked on complex querys, if there is no logic at ETL side you need have to write it at database level can you handle it. ================================================================================================================================================== UST GLOBAL ============= ----------- 93.What are all the change data capture methods that your aware of. 94.What is the importance of Md5 function rather than comparing each and every column 95.If we want to create a looping task how will you do it 96.If the data is coming from a database how will you do it for looping 97.In Script Task how will you configure the Script Task to handle any error. What is the property name for error handling in command task 98.what is the purpose of assignment task. 99.If your not using the bulk load how exactly will you recover it. 100.Whats the difference b/w bulk load and normal load with respect to the log files 101.How do you recover the data from normal load, how does the recovery property work 102.What will be the approach for sql query having a performance issue. 103.Emp and depart table how will you identify those set of recored for which in emply table dont have any depart numbers 104.What is the parameter in Substing and Insting function, how to get the end of string 105.SDC-Type 2 Explantion at column level rather than a Date level 106.What is the use of Sorted Input in Aggreator, internally what will happen.

IICS ONLY ---- 1.how many mappings and how and what trnasformations used in your project 2.macros what is macros , types, and how and where we can use 3.indirect file method in informatica replaced which menthod in iics 4.what is hierarchaical schema and fixed width format 5.how can you handle json and xml file formats 6. how do u run 3 tasks in parallel and next task needs to trigger after this 3 tasks completion ? so which tasks we need to use this for this complete work 7.can u cretae the mapping and mct with out secure agent 8.AGGREGATIONS is used in dimension tables or fact tables 9.what is the output for this unix commands tail -1 file.txt chmod 400 grep -c "unix" file.txt sed $d file1.txt 10.-How you deployed code is IICS, was it automated !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! -- A.Have you worked on Jenkins and GITHUB 11.17) How to calculate the cum_sales Year Quarter Sales 2013 Q1 1000 6000 2013 Q1 5000 6000 2013 Q2 6000 13000 2013 Q2 7000 13000 2013 Q3 8000 17000 2013 Q3 9000 17000 2013 Q4 10000 21000 2013 Q4 11000 21000 2014 Q1 12000 25000 2014 Q1 13000 25000 2014 Q2 14000 29000 2014 Q2 15000 29000 2014 Q3 16000 33000 2014 Q3 17000 33000 2014 Q4 18000 37000 2014 Q4 19000 37000 2015 Q1 20000 41000 2015 Q1 21000 41000 2015 Q2 22000 45000 2015 Q2 23000 45000 2015 Q3 24000 49000 2015 Q3 25000 49000 2015 Q4 26000 53000 2015 Q4 27000 53000 select year, qtr, sales, sum(sales)over(partition by year, qtr order by year, qtr) as cum_sales from sen_6 ORDER BY Year, QTR; 19) Table1 Table2 1 1 1 1 1 1 1 1 1 3 tell me All the types of joins results 13.20) Col1 colb 1 0 0 1 1 0 1 1 what is your query to get the reverse values of the col1 in colb !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 14.How do you integrate CDQ Component in CDI Dataflow? 15.What to create a generic mapping, the target is always Drop and Replace, Source is a flat file but i dont know the structure of it My challenge is to create a dynamic mapping, so that it will detect any kind of flat file, and process to the target table at create table at runtime, today i get comma, tomorow i may get pipe delimiter and so on. how can i implement this senario. 16. How will you handle Nullability while using MD5 function, if there are 10 columns are null, in the incoming 15 columns how do you handle it. 17. Alternative of md5 function in informatica powercenter (CRC32) 18. What is the difference between FTP and SFTP 19. How do you ingest data into Snowflake 20.I have taskflow with multiple tasks like datatask, notification task, command task and many more how to parameterisie this completely i want to assign taks flow level parameters values dynamically, how can we achive this. 21.What the struturee of the parameter file if we have input connectin, data objects, expression variables for smooth execution of the mapping 22. What are the window functions available in Oracle or in advance 23. Senario EMP no name Dep_Name Salary 1 raj IT 100000 Output: Emp Pivot 1 raj IT 10000 HARMAN2 L2 ROUND 1)How to delete duplicates in Snowflake 2)AWS S3 Bucket i have load to one of the snowflake stage table how can we do it? 3) Do you know what is the differnece between Parameter Set and Parameter File. 4) When you concate 2 columns and 1 column has null what will be the output result. 5) What is the difference between the Input fields and temp fields 6)10 Source Files data from each location we are getting they are having different department, we dont know how many departments are there how can we create flat files as targert for each department 7)IICS Taskflow how are you scheduling the Taskflows, are you using any external tool 8)How can we add dependancies b/w 2 different taskflows in IICS and how can we schedule it. ---------------------- INFOSYS 31.How do you load Jason file in IICS --------------------------------------------------------------------------- LEGATO HEALTH 32.select * from table_name Where true - what is the output of this query 33. What is snowflake stages 34. What are the file formats available in Snoflake, 35. What is zero copy cloning --------------------------------------------------------------------------------------------------------------------------------------------------- MASS MUTUAL COMAPANY ---------------- If we have link condition in taskflow how do you give that to next task in IICS 10)What are all the diffierece b/w command task in powercenter and IICS 11)Email task and notification task diffierece b/w powercenter and IICS 12. Give all join COndition Table A Table B 1 1 2 1 null null null null 3 2 12.Unix questions -How to display last line in file -command used to search for a string -How to delete 5th line in file -Command to list all files and directories -How to make file executable ============================================================================================================= TRIANZ COMPANY & UST GLOBAL -------------- 40.How can we troubleshoot any error in IICS ? 41.What is the purpose of iterated task in taskflow 42.

how to use lead and lag function in informatica

will you also explian sequential task with decision

can we do incremental loading for all ?

need answers for these interview questions ------ QUESTION: Workflow rejected 50 records in the production what is your next step ? 1.How do you raise ticket? 2.In case of job failure in production whom will you report ? 3.Explain end to end project life cycle from dev to production ? 4.How will you get updates in your projects from your client 5.Project - what is customer perspective in detail ? 6.Can you plese tell me some acheivements done by you in your project ? 7.Explain end to end project life cycle from dev to production ? 8.What all other tools use in your project ? 9.What is the flow of development in your project ? 10.If there are errors in UAT phase how will you resolve it how you are manintaing versions ? 11.Query to split fullname into first name , middle name , last name (3columns)? 12.How we will get to know whether previous commnad executed in a script is successful or not ? 13.What is MD5 function ? 14.How you troubleshooting when workflow is failed ? 15.How you worked in sprint basis or what is the sprint time ? ---------- 16. Suppose if source file has junk records how would you remove it , will you remove it before importing to power center or after importing power center ? 17. in Scd type2 scenario we have some records in target If i have to insert first instead of updating What would happen ? will it give error or ? 18.how to achieve sccd type 2 without end_date ?what will happen ? 19.Are you comfortable if you been placed to big data management projects ? 20.What output files does informatica create during running session ? 21.Can we store previois seesion logs ? If yes How ? 22.Used update strategy in mapping but records are only getting insrted not updated why 23.Actually how you exatcly fit into this project ? 24.Few complex queries how you check it ? 25.HLD and LLD documents? 26.Md5 function ? 27.If there is requirement to supportbover weekend where there is a critical due to timelines will yoi be able to support and manage 28.Etl process to downstream ? 29.Dataware concepts ? 30.Sales table and metadata table - update the source as sales table and how to check the metadata value un target 31.What is project source name 32.How to pass values between seesion in a workflow 33.Find the 1,2,3 highest salary without using rank function ? 34.Is it neccesary to enable sorter input option in joiner 35.What is incremental aggregation 36.What is trigger 37.How to optimize mapping 38.Types of data you are getting for your project 39.How many ways we can override the query 40.How will do error handling 41.In informatica. If you jave spicial characters in the column first name how will you remove it ? 42.How to remove duplicates in unix ? 43.If source has 1000 records. Which partition is used to load 100 records to 10 targets ? 44.How to pass one session parameter to another session ? Persistent cache ? 45. What are different type os parallel processing ? 46.How will concatenate using unix ? 47.Target override ? 48.Which is better operator like or exists ? 49.Can you tell your project architecture ? 50.How does informatica tool works 51.What is the difference between function and procedures 52.Diffrence bettwenn session log and workflow log 53.Do you know about migrations 54.Source bottle neck how to refuse it ? 55.How to find second row in a file

3. How many mapping have you created all together in your project? I did over 35+ mappings, around 10+ were complex mappings. 4. In which account does your Project Fall? hope its manufacturing and advanced services. 5. What is your Reporting Hierarchy? me --team lead---Project Manager---programming Manager me--- AR---HR 6. How many Complex Mapping’s have you created? Could you please me the situation for which you have developed that Complex mapping? i think 8 , one for character by character comparision (with informatica not possible) so written 950 lines if single SQL code. and one for Dynamical Hierarchy distribution .... and one for Multi byte characters ( japanes,chines,..etc) and so on… 7. What is your Involvement in Performance tuning of your Project? some times any way performance team will take care of my code 8. What is the Schema of your Project? And why did you opt for that particular schema? some_Prd ---that is the souce for us 9. What are your Roles in this project? as a developer , desing the workflows , unit testing, and so on... 10. Can I have one situation which you have adopted by which performance has improved dramatically? yes ..... my first project ..i faced performance issue after go live. 11. Where you Involved in more than two projects simultaneously? of couse ,, i involved 3 projects at a time. 12. Do you have any experience in the Production support? yes/no 13. What kinds of Testing have you done on your Project (Unit or Integration or System or UAT)? And Enhancement’s were done after testing? Unit testing and sometimes integration. UAT will done by business not BI team. 14. How many Dimension Table are there in your Project and how are they linked to the fact table? current project 18 and 2 facts . and relationship will always be dimention keys. 15. How do we do the Fact Load? after dimension load complete .. 16. How did you implement CDC in your project? It is always on souce modification date. 17. How does your Mapping in File to Load look like? souce ---ods---flat file ( .dat) -- e cap delimeter 18. How does your Mapping in Load to Stage look like? is depends on project ... Souce --ods---stage 19. How does your Mapping in Stage to ODS look like? Stage to ods ??? never … 20. What is the size of your Data warehouse? 40 TB 21. What is your Daily feed size and weekly feed size? 22. Which Approach (Top down or Bottom Up) was used in building your project? Bottom up ---i mean you are asking about dimention to fact and fact to dimention?? 23. How do you access your source’s (are they Flat files or Relational)? Relational and some times flat files also 24. Have you developed any Stored Procedure or triggers in this project? How did you use them and in which situation? no 25. Did your Project go live? What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? yeah...i faced some issues. 26. What is the biggest Challenge that you encountered in this project? Dynamic hierarchy data distribution and moving the files from unix box to informatica directory through shell script , need to clean the data in flat file itself. 27. What is the scheduler tool you have used in this project? How did you schedule jobs using it? Dollar Universe.. by using $U Sessioin task. informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial

INTERVIEW QUESTIONS NEED ANSWERS PLS I HAVE TRIED BUT UNABLE TO CREATE MD5 FUNCTION PLS GIVE A PRACTICAL VIDEO EXPLANATION ? 1.What is your Reporting Hierarchy? 2.What is your Involvement in Performance tuning of your Project? 3. Can I have one situation which you have adopted by which performance has improved dramatically? 4. Do you have any experience in the Production support? 5. Did your Project go live? What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? 6. How to import oracle sequence into Informatica? 7. How do we implement recovery strategy while running concurrent batches? 8. What are the types of meta data repository stores? 9. Can you use the mapping parameters or variables created in one mapping into another mapping? 10. Explain what DTM does when you start a work flow? 11.Explain what Load Manager does when you start a work flow? 12. Can we use an active transformation after update strategy transformation? 13. While importing the relational source definition from database, what are the meta data of source U import? 14. Informatica is complaining about the server could not be reached? What steps would you take? 15.If your workflow is running slow, what is your approach towards performance tuning? 16.Explain CLOUD ARCHITECTURE ? 17.What is change data capture? 18.WHAT IS ODS LAYER /STAGE WHY WE USE IT ? 19.Your session failed and when you try to open a log file, it complains that the session details are not available. How would do trace the error? What log file would you seek for?

Nice

1.What is your Reporting Hierarchy? 2.What is your Involvement in Performance tuning of your Project? 3. Can I have one situation which you have adopted by which performance has improved dramatically? 4. Do you have any experience in the Production support? 5. Did your Project go live? What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? 6. How to import oracle sequence into Informatica? 7. How do we implement recovery strategy while running concurrent batches? 8. What are the types of meta data repository stores? 9. Can you use the mapping parameters or variables created in one mapping into another mapping? 10. Explain what DTM does when you start a work flow? 11.Explain what Load Manager does when you start a work flow? 12. Can we use an active transformation after update strategy transformation? 13. While importing the relational source definition from database, what are the meta data of source U import? 14. Informatica is complaining about the server could not be reached? What steps would you take? 15.If your workflow is running slow, what is your approach towards performance tuning? 16.Explain CLOUD ARCHITECTURE ? 17.What is change data capture? 18.WHAT IS ODS LAYER /STAGE WHY WE USE IT ? 19.Your session failed and when you try to open a log file, it complains that the session details are not available. How would do trace the error? What log file would you seek for?

CAN YOU EXPLAIN md 5 practical doing explanation informatica with real example

CAN YOU EXPLAIN md 5 practical doing explanation informatica with real example

Hi ,any difference in union transformation ( pc vs cloud ) aske in interview bro

Your explanation is good

BRO ,I HAVE DOUBT CAN WE JOIN HETEROGENOUS DATANBASE IN UNION TRANSORMTION , i heard we can do only in joiner transforamtion

How it is possible in iics to read multiple excel files as tables which has been downloaded from SharePoint Online connector without using Microsoft excel conncteor and need to store the transform data in informatica local storage. As in Microsoft Excel connector we need to create seperate connection for each excel sheet data.Thanks in advance.

Hi.. I am learning sql and power center and iics and extra skills required for data engineer??

Great ❤

Best video ever seen on snowflake ❤ Thanks

Nice 👌

Great knowledge it will definitely help me a lot

Good 👍