Hi Every One When i Start the Workflow, Table is Going to be
Stored in the target database But the columns are not going
to the target database table in my PC , please give me the
solution and waiting for solution
Answers were Sorted based on User's Feedback
Answer / swaroop(atiric)
once check out with ur transformations , the output ports
should generate the proper data as per the given conditions
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / komala
once check out your output ports and input ports and the
pipeline between
Is This Answer Correct ? | 1 Yes | 0 No |
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
Why we select the table which has minimum number of records as Master table in joiner?
what is lookup ?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
How to view and Generate Metadata Reports?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Why we use stored procedure transformation?
In a concurrent batch if a session fails, can you start again from that session
how may sources can be used in a mapping at a time?(limit)
replace multiple spaces with single space.
How is union transformation utilized?