In this post I will explain the job design to generate sequence numbers in Column Generator stage. Sample job design would be like below: open the column generator stage …
Did you get any requirement to compare two parallel/sequence jobs? If Yes, then this post is for you and you can compare not only jobs but also almost all …
PROBLEM STATEMENT: Pivot the ‘Occupation’ column in OCCUPATIONS table so that each ‘Name’ is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers should be Doctor, …
MinutesFromTime function returns the minute portion of a time. Input: time Output: minutes (int8) Examples. If mylink.mytime contains the time 23:20:50, then the two following functions are equivalent, and …
1. What is a data warehouse? A data warehouse is the electronic storage of an organization’s historical data for the purpose of data analytics. In other words, a data …
You are using WinSCP and don’t see the files beginning with dot (hidden files) like .config or .dir? These are hidden files. WinSCP has a configuration setting that allows …
Read previous post: Informatica interview questions and answers-3 31. If a sequence generator (with increment of 1) is connected to (say) 3 targets and each target uses the NEXTVAL …
