Really wonderful explanation. i actually saw this video at my office by keeping sound mute but your subtitle goes somewhere else :D it shows like WI-FI, Defense once i reach to home. i saw this video again with earphone. great please do more videos especially, once we we complete all the transformation do we create any batch to run?
ex: column1,column2 10,banga,lor 20,hyd 30,chenn,ai how handle this, If upload directly column2 data is splitting. out put in target should be as is in source
. I have a file which contains 2 columns like below: col1 col2 1 AB 2 B 6 C 52 CK 33 DM The first column is Integer number and second is string The requirement is to repeat the second column (i.e.., String value) as many times as mentioned in first column Sample result: col1 col2 1 AB 2 BB 6 CCCCCC 52 CKCKCKCK......52 times 33 DMDMDMDMDM.......32times Achieve the above logic in informatica. can u plss slove this for me
Excellent
Thank you
Great job sir
Commendable. Very nicely covered each and everything
please share informatica scenario base 50 questions
thanks for saif this is wonderful explanation .
Good explanation
My set file properties is disabled .Can someone pls help me
like how to enable it
what if the order of delimiters are not in the order, can you explain that? for ex: first row it is |@$, and second row $@,|
Can we havr answer for this if the delimiters are not have particular sequence
Hi , I have comma delimited flat file with 2 columns , first columns has comma in data itself . how to handle it while loading
Really wonderful explanation. i actually saw this video at my office by keeping sound mute but your subtitle goes somewhere else :D it shows like WI-FI, Defense once i reach to home. i saw this video again with earphone. great please do more videos especially, once we we complete all the transformation do we create any batch to run?
ex: column1,column2
10,banga,lor
20,hyd
30,chenn,ai
how handle this, If upload directly column2 data is splitting. out put in target should be as is in source
. I have a file which contains 2 columns like below:
col1 col2
1 AB
2 B
6 C
52 CK
33 DM
The first column is Integer number and second is string
The requirement is to repeat the second column (i.e.., String value) as many times as mentioned in first column
Sample result:
col1 col2
1 AB
2 BB
6 CCCCCC
52 CKCKCKCK......52 times
33 DMDMDMDMDM.......32times
Achieve the above logic in informatica.
can u plss slove this for me
Try lpad. First u give a try if it doesn't work lemme know.
Good explanation