tag:blogger.com,1999:blog-1936665928568066047.post6830158864212748163..comments2023-12-27T03:13:34.514-08:00Comments on Radhakrishna Sarma: How to generate target file names dynamically from the mapping?Radhakrishna Sarmahttp://www.blogger.com/profile/15531516106199587979noreply@blogger.comBlogger72125tag:blogger.com,1999:blog-1936665928568066047.post-41746925590750482552015-11-10T09:44:26.377-08:002015-11-10T09:44:26.377-08:00Hi RadhaKrishna,
I have a requirement where I nee...Hi RadhaKrishna,<br /><br />I have a requirement where I need to capture the source filename, date(File created), no: of records, file size. Can you please help me on how to capture this information.<br /><br />Thanks & Regards,<br /><br />SrikanthAnonymoushttps://www.blogger.com/profile/16388717010693400274noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-48628943332214699982015-01-13T23:03:41.933-08:002015-01-13T23:03:41.933-08:00Hi Radha,
I have one issue on dynamic file creati...Hi Radha,<br /><br />I have one issue on dynamic file creation.<br /><br />I have to generate one dynamic flat file from three flows (database).<br /><br />It should be like below :<br /><br />Source 1:<br />***************<br />Eno Ename DeptNo<br />---- -------- -------- <br />1 X 10<br />2 Y 20<br /><br />Source 2:<br />********************<br />DeptNo Dname<br />----------- -------<br />10 Finance<br />20 HR<br /><br /><br />and my target flat file should look like below :<br /><br />Target :<br />-----------<br /><br />Eno Ename DeptNo<br />--------- ------------- ---------<br />1 X 10<br />2 Y 20<br /><br />DeptNo Dname<br />---------- --------<br />10 Finance<br />20 HR<br /><br />Please help me on the above issue.<br /><br />Thanks and Regards,<br /><br />NagNagarjunahttps://www.blogger.com/profile/13754052539123510589noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-68972807655113761792013-08-08T23:28:28.225-07:002013-08-08T23:28:28.225-07:00hi .....this is manish
supose my source is flat f...hi .....this is manish <br />supose my source is flat file data is look like a -99.99 imy target is -9999 how it possible in informatica Anonymoushttps://www.blogger.com/profile/14702208081417354227noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-71881061240204772802013-07-15T07:14:38.469-07:002013-07-15T07:14:38.469-07:00HI Radha,
When i have zero records in source.I am...HI Radha,<br /><br />When i have zero records in source.I am unable to create flatfile with date_stamp.Only Filename file with zero byte is created .<br />Can you please helpe me out on this.<br /><br />regards,<br />SripriyavAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-87205961467588820982013-05-24T02:53:08.704-07:002013-05-24T02:53:08.704-07:00SUPERB, MARVELOUS, EXCELLENT work Radhakrishna.......SUPERB, MARVELOUS, EXCELLENT work Radhakrishna..... Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-64562181974243303402013-05-03T14:57:39.920-07:002013-05-03T14:57:39.920-07:00Thank you! Thank you! Thank you! I was going nuts ...Thank you! Thank you! Thank you! I was going nuts with what I was missing. It was the 'special port'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-77589000303582207832013-04-30T09:38:02.211-07:002013-04-30T09:38:02.211-07:00But one issue is. when there are "zero record...But one issue is. when there are "zero records to pull" im not able to see the empty file created? i there a way to over come this issue using the above explained method.Am i Missing Something...??https://www.blogger.com/profile/11543291581193981315noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-35791260861180317182013-04-01T22:19:36.427-07:002013-04-01T22:19:36.427-07:00Hi Sharma,
i have requiremnet similar to this but...Hi Sharma,<br /><br />i have requiremnet similar to this but here target is XML.<br />If from the source table is trying to more than 4400 records then i have create one more XML file .<br />How could i do thru Informatica Dyanmically..<br /><br />can you please provide me some inputs on this.iam stuck on this issue. ihave one more alternative is thru unix Scripts..Can you please guide me on the same Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-17294009804987361762013-03-07T05:32:36.628-08:002013-03-07T05:32:36.628-08:00Thanks for the solution. I have also written a sim...Thanks for the solution. I have also written a similar post on flat file generation.<br /><br /><br />Check out the link<br /><br /><a href="http://www.folkstalk.com/2012/02/dynamic-flat-file-generation-in_10.html" rel="nofollow">Dynamic Target Flat File Name Generation in Informatica</a>data warehouse forumhttp://queforum.com/data-warehouse/noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-81482702241689825672013-02-22T08:08:12.023-08:002013-02-22T08:08:12.023-08:00How to remove # from headers for files created dyn...How to remove # from headers for files created dynamically<br /><br />I have a mapping as below which creates files dynamically.<br /><br /> <br />SQ -> SRT -> EXP -> TRANS_CONTROL -> TGT-<br /><br /> <br />I am using the filename port in my target to create the files and its working fine.<br /><br /> <br />I want to generate column header's for each file. I am using the 'Header options' in my session properties. <br />But this adds a '#' as the first character to the header row which I don't require.<br /><br /> <br />How do I ignore the '#' in my header row for the files generated dynamically?<br /><br /> <br />Thanks,<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-80715135949467269062013-02-11T04:30:43.229-08:002013-02-11T04:30:43.229-08:00Hi Sharma
Its good you are helping many people t...Hi Sharma <br /><br />Its good you are helping many people through this blog.<br /><br />Could you please tell me when the target is DB like oracle is it possible to generate file names along with the records.<br /><br />Thanks<br />PrasadPrasadnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-77797958131083275772012-10-16T17:15:30.920-07:002012-10-16T17:15:30.920-07:00Hello Radhakrishna
Thanks for the detailed explana...Hello Radhakrishna<br />Thanks for the detailed explanation. We are building a real time messaging solution with UMQ. It seems this option doesnt work with real time messaging. Any ideas? Please let me know.<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-6153916926866022042012-08-30T15:16:56.852-07:002012-08-30T15:16:56.852-07:00Hi Sarma,
I am relatively new to informatica compa...Hi Sarma,<br />I am relatively new to informatica compared to other bloggers here.I am working on a reaquirement where I need to create a file per each state with timestamp suffix.<br /><br />state,x,y,z<br />NY<br />NY<br />NY<br />PA<br />NJ<br /><br />exp filenames - (ny_08302012.txt, nj_08302012.txt, pa_08302012.txt). <br />I know others have already asked you this question but i don't know which of your responses to follow.<br /><br />Please email if you wish to - krishnaj.prsd@gmail.comAnonymoushttps://www.blogger.com/profile/02949461548973422381noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-91496701578547577172012-02-07T06:29:51.959-08:002012-02-07T06:29:51.959-08:00Really excellent. You can find some more scenarios...Really excellent. You can find some more scenarios on dynamic file creation at <a href="http://www.folkstalk.com/2012/02/dynamic-flat-file-generation-in.html" rel="nofollow">Dynamic File Creation in informatica</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-30201909038140308932011-12-12T20:11:34.454-08:002011-12-12T20:11:34.454-08:00Hi Radha really excellentHi Radha really excellentRijju Akbarhttps://www.blogger.com/profile/09515987112834390426noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-46761620006620800522011-12-12T20:09:54.200-08:002011-12-12T20:09:54.200-08:00U R doing an excellent job.U R doing an excellent job.Rijju Akbarhttps://www.blogger.com/profile/09515987112834390426noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-13653726604670957072011-12-11T21:33:04.892-08:002011-12-11T21:33:04.892-08:00Radhakrishna,
Really your explanation is too goo...Radhakrishna,<br /> <br />Really your explanation is too good but here i have another query for you after creating the files dynamically i want to know how many records exist in that file how can you achieve this ......<br /><br />Thanks in advance!Ranithhttps://www.blogger.com/profile/15727088465321675035noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-46562348610017220342011-11-02T20:40:36.075-07:002011-11-02T20:40:36.075-07:00Hi RadhaKrishna,
Can you please help me on the bel...Hi RadhaKrishna,<br />Can you please help me on the below design.<br />I have a requirement of creating target files of each 25000 records in it with dynamic file names and also need to have the header and trailer for each target flat file with the dynamic file name.The source is RDBMS.<br /><br />Note : I am able to generate multipl files with dynamic names but only the logic i am missing to populate header and trailer for each file.<br /><br />Please find my email venu.etl123@gmail.com.<br /><br />Thank you,<br />venuvenubabuhttps://www.blogger.com/profile/03237841983298870762noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-76922283659842488602011-08-15T00:06:31.686-07:002011-08-15T00:06:31.686-07:00Heyy Radha....
I have used this option in the map...Heyy Radha....<br /><br />I have used this option in the mapping and connected this port of the target definition with <br />'a_'||Filename_dt_v||'_b.txt'. But the desired file is not being generated in my target directory. <br /><br />The dummy file fileoutput.txt is alone being generated in the output directory.Arunnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-7414157487083531742011-07-07T22:17:47.165-07:002011-07-07T22:17:47.165-07:00Hi radha krishna garu,
add new file (F) icon is n...Hi radha krishna garu,<br /><br />add new file (F) icon is not seen in my system. can you please tell me how can i retrieve that.<br /><br />chaitanyachaituhttps://www.blogger.com/profile/15042117937650539303noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-35736725321572427852011-07-05T08:14:59.703-07:002011-07-05T08:14:59.703-07:00forgot to mention mailid
preythap@gmail.comforgot to mention mailid<br />preythap@gmail.compreythaphttps://www.blogger.com/profile/15702509709798532919noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-11419877282215225602011-07-05T08:12:19.291-07:002011-07-05T08:12:19.291-07:00Hi Radhakrishna sarma..
thank you so much for the ...Hi Radhakrishna sarma..<br />thank you so much for the valuble info.<br />am newbie in Informatica if you have any scenario based questions or examples please mail me.<br /><br />Thankspreythaphttps://www.blogger.com/profile/15702509709798532919noreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-49034483991588124702011-06-14T20:51:52.301-07:002011-06-14T20:51:52.301-07:00Hi Radhakrishan,
Thanks for your info.My requirem...Hi Radhakrishan,<br /><br />Thanks for your info.My requirement is to append a timestamp to the target .csv file and SFTP to a remote server.Could you please share some info on how we can achieve this?Arvindnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-13959409522685851792011-05-30T09:36:02.926-07:002011-05-30T09:36:02.926-07:00´m getting "WRT_8004 Writer initialization fa...´m getting "WRT_8004 Writer initialization failed [Error opening session output file [/home/infrmtca/Informatica/PowerCenter8.6.0/server/infa_shared/TgtFiles/] [error=Is a directory]]. Writer terminating.<br />WRT_8064 Error opening session output file [/home/infrmtca/Informatica/PowerCenter8.6.0/server/infa_shared/TgtFiles/] [errno=21] [error=Is a directory]"<br /><br />WHAT WOULD BE THE REASON FOR THIS AND I HAVE ALL PERMISSIONS ON TARGET FOLDER...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1936665928568066047.post-8185074905525138552011-04-23T19:57:28.574-07:002011-04-23T19:57:28.574-07:00Thanks a lot it was a fantastic support, now to ge...Thanks a lot it was a fantastic support, now to generate target file names dynamically from the mapping? is simple utilizing your advice. KudosRachat de credithttp://www.7rachat-credits.comnoreply@blogger.com