Informatica Normalizer Concatenation Error

Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Groups Ask a New Question Informatica The Informatica group is your premier resource for objective technical discussion and peer-to-peer support on Informatica data integration software. Home | Invite Peers | More Data Warehouse Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. normalizer - Concatenation error Satya asked Nov 1, 2004 | Replies (2) Hi all, I am using normalizer to convert from row to columns. Input is a joined sql statement having 7+69 columns. first 7 should be transformed ass and next 69 should be transformd as rows. So i have level and occurence like this. col1 1 1 col2 1

Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/normalizer-concatenation-error-583159 Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Groups Ask a New Question http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/normalizer-problem-709971 Informatica The Informatica group is your premier resource for objective technical discussion and peer-to-peer support on Informatica data integration software. Home | Invite Peers | More Data Warehouse Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Normalizer problem inofrmatica_buddy asked Apr 14, 2005 | Replies (4) Hi Guys, We have COBOL file as our source,with that comes the normailzer transformation ,i was doing a straight push to db2,its giving concatinat

ETL Suggest New Category If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F). Question Posted / suneetha.d 1 Answers http://www.allinterview.com/showanswers/117365/if-concatenate-data-from-normalizer-transformation-ports-cannot-include-occurs-t.html 7346 Views I also Faced E-Mail Answers

Answer / guest using normalizer tab Is This Answer Correct ? 3 Yes 2 No Post New Answer Categories Teradata (205)Business Objects (780)Cognos (888)Informatica (1801)Crystal http://informaticatool.blogspot.com/ Enterprise Suite (29)Actuate (36)Ab Initio (209)Data Stage (636)SAS (599)Micro Strategy (41)ETL (208)OBIEE (45)Data Warehouse General (219)
More ETL Interview Questions how do u extract data from different data sources explain with an example? 0 informatica normalizer Answers Difference between flat files and relational sources? 0 Answers What is factless fact schema? 3 Answers my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica 1 Answers HCL, what is the difference steps for data modeling? 0 Answers Can anyone explain me a scenario from banking and finance...more precisely a informatica normalizer concatenation mapping 0 Answers IBM, what happens if the info.server doesn't find the session parameter in the parameter file? 0 Answers Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping. 0 Answers What is the main difference between peek stage and copy stage 2 Answers Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat? 5 Answers what are the different Reporting and ETL tools available in the market? 3 Answers in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain? 2 Answers Accenture, For more ETL Interview Questions Click Here







Copyright Policy | Terms of Service | Site Map | Contact Us Copyright © 2016 ALLInterview.com. All Rights Reserved.

a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data.Transformations can be of two types:Active TransformationAn active transformation can change the number of rows that pass through the transformation, change the transaction boundary, can change the row type. For example, Filter, Transaction Control and Update Strategy are active transformations. The key point is to note that Designer does not allow you to connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group because the Integration Service may not be able to concatenate the rows passed by active transformations However, Sequence Generator transformation(SGT) is an exception to this rule. A SGT does not receive data. It generates unique numeric values. As a result, the Integration Service does not encounter problems concatenating rows passed by a SGT and an active transformation.Passive Transformation.A passive transformation does not change the number of rows that pass through it, maintains the transaction boundary, and maintains the row type.The key point is to note that Designer allows you to connect multiple transformations to the same downstream transformation or transformation input group only if all transformations in the upstream branches are passive. The transformation that originates the branch can be active or passive.Transformations can be Connected or UnConnected to the data flow.Connected TransformationConnected transformation is connected to other transformations or directly to target table in the mapping. UnConnected TransformationAn unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.Following are the list of Transformations available in Informatica:Aggregator TransformationAggregator transformation performs aggregate funtions like average, sum, count etc. on multiple rows or groups. The Integration Service performs these calculations as it reads and stores data group and row data in an aggregate cache. It is an Active & Connected transformation.Difference b/w Aggregator and Expression Transformation? Expression