Scenarios Set 2

21. I have 10000 records. First time I have to load 1 to 1000 records, second run I have load 1000 to 2000 records and third load I have to load 2000 to 3000 rows. How will achieve

22. I have a source either file or DB table

EmpNo	Ename	Salary	DeptNo
101	Raju	100	1
102	Ashley	200	2
103	Kamle	300	3
104	Ravi	76	1
105	Anil	120	2

I want to run a session 3 times.

First time:     it should populate dept 1 only

Second time: it should populate dept 2 only

Third time:     it should populate dept 3 only 

23. A source file having customer names and contact number like:

Source:

Customer_Name	Customer_Numbers
ABC	Ct1, Ct2, Ct3
XYZ	Ct1, Ct2, Ct3, Ct4, Ct5
DEF	Ct1, Ct2
GHI	Ct1, Ct2, Ct3, Ct4, Ct5, Ct6, Ct7

Target:

Customer_Name	Customer_Numbers
ABC	Ct1
ABC	Ct2
ABC	Ct3
XYZ	Ct1
XYZ	Ct2
XYZ	Ct3
XYZ	Ct4
XYZ	Ct5
DEF	Ct1
DEF	Ct2
GHI	Ct1
GHI	Ct2
GHI	Ct3
GHI	Ct4
GHI	Ct5
GHI	Ct 6
GHI	Ct7

Ans: This Can be down using Java transformation by holding record wise customer number in an array and looping it.

like If(I=1, I<=#, I++).

24. I have a source table

Source

ID	Name	Salary
101	A	15000
102	B	25000
103	C	12000

target load should be  

ID	Name	Salary
101	A	15000
101	B	25000
101	C	12000
102	A	15000
102	B	25000
102	C	12000
103	A	15000
103	B	25000
103	C	12000

25. I am having SOURCE as: 

1000,null,null,null

null,2000,null,null

null,null,3000,null 

null,null,null,4000 

Now I want the OUTPUT as: 

1000,2000,3000,4000

I want to eliminate nulls and want in a single line.

26. A source file having 100 records and in mapping sequence generate max is defined as 99 and re-cycle option was not check. Then what will happen to 100th row.

Ans: Will get the error message out of sequence value.

27. Source : 

ID	Name
10	A
10	A2
10	A4
10	A5
10	A3
20	B
20	B2
20	B4
30	C
30	C8
40	D

Target :

ID	Name
10	A
101	A2
102	A4
103	A5
104	A3
20	B
205	B2
206	B4
30	C
307	C8
40	D

28. I have the following table

SOURCE:

COL1

1

Gowtham

35000

2

Aarman

25000

Target as:

Row ID	Name	Salary
1	Gowtham	35000
2	Aarman	25000

  

29. Achieve the following.

Source:

Col1	Col2	Col3
A	B	C
D	E	F
G	H	I
J	K	L

Target:

Col1	Col2	Col3	Col4
A	D	G	J
B	E	H	K
C	F	L	L

30. I have 10 set of files with same structure and same no of columns. I want loaded into 3 target tables/files.
1st, 4th, 7th, 10th records from each file into 1st target.
2nd, 5th, 8th records from each file into 2nd target.
3rd, 6th, 9th records from each file into 3rd target.

31. I have 5 files of same structure and no of columns. I want to load them in a single target table. (With file list). In case my job got failed due to any bad record, I want to know the input file name from which that bad record having.

32. How to load data incremental without using parameter file.

33. What is pipe line source and lookup?

34. How to read source/lookup file from outside of informatica server and write data into a file which is outside of the informatica server.

35. An audit Job used in needs to use more than a workflows or folders.

36. A workflow is scheduled to run on week days but on specific day it should perform a specific action based on the weekday.

37. On daily basic one will be copied to the server and on the every month end a workflow should load those files to a table. (File List/Indirect method cannot be used due to some joiner/aggregation process is there)
ex: 31 files in Jan, 28/29 files in Feb, 31 files in Mar, 30 files in Apr, etc.

38. I have 2 workflows, 1st workflow will load 50 files one after the other whenever file received in the server and 2nd workflow should start after loading those 50 files.

39. How to develop a single mapping for Full Load and Incremental load.

40. I have a workflow which is having event wait, timer for 8 hours and after 8 hours in case event wait not execute (ready file not available) then workflow should auto forced succeeded. To avoid running 2 instances in next day.