Hi,
I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.
The Target are Oracle tables.
1-80 columns: 1st target
81-200 columns:2nd target
How can I split that single COBOL file data into two data files...

Sravan Kumar

• Dec 21st, 2006

USE NORMALIZER TRANSFERMATION.

Answer Question  Select Best Answer

Kapil

• Oct 11th, 2006

Hi Flat files have some advantages which normal table does not have. First one is explained by first post. Secondly, Flat file can work with case sensitivity issue of data easily., where normal table has errors.Kapil Goyal

opbang

 Profile Answers by opbang Questions by opbang

• Oct 5th, 2006

Loading data from flatfiles to database is faster. You are receiving a data from a remote location. At remote location the required data can be converted into flatfile and same you can use at target location for loading. This minimizes the requirement of bandwidth, faster transmission.

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

If  the relationship to other table is a one to one join or many to one join then we can use lookup to get the required fields.  In case the relationship is outer join, joining both the...

srinivas vadlakonda

• Oct 11th, 2006

Yes we can use the lookup transformation instead of joiner but we can take the homogeous sources only. If u r taking joiner we can join the heterogeneous sources.

Answer Question  Select Best Answer

ravi guturi

• Oct 17th, 2006

Main advantage in starschema1)it supports drilling and drill down options2)fewer tables3)less databaseIn snowflake schema1)degrade query peformance because more joins is there2)savings small storage spaces

srinivas.vadlakonda

• Oct 16th, 2006

Schemas are two types starflake and snowsflake schema, In starflake fact table is in normalized format and dimention table is in denormalized formatIn snowsflake both fact and dimention tables are in ...

Answer Question  Select Best Answer

Kuldeep Kumar Verma

• Dec 26th, 2006

Auxiliary Mapping is used to reflect change in one table when ever there is a change in the other table.Example:In Siebel we have S_SRV_REQ and S_EVT_ACT table, Lets say that we have a image table def...

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

If the no. of records are in hundreds, one doesn't see much difference whether a static cache is used or dynamic cache.  If there are thousands of records dynamic cache kills time because it commits the database for each insert or update it makes.

srinivas vadlakonda

• Oct 17th, 2006

Specific situation is not there  to use the dynamic lookup if u r using the dynamic it will increase the performance and also it will minimize the  transformation like sequence generator.

Answer Question  Select Best Answer

Sakthivel

• Oct 17th, 2006

Thank you very much Subbarao..

subbarao.g

• Oct 16th, 2006

There are two types of flate files:1.Delimtedwidth2.Fixdwidth

Answer Question  Select Best Answer

phani

• Nov 29th, 2006

Hi friend,If there is an error comes it stored it on target_table.bad file.The error are in two type1. row-based errors2. column based errorscolumn based errors identified byD-GOOD DATA N-NULL DATA O-...

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

Yep, Use joiner transformation to join heterogeneous sourcesDevelop the mappingIn the Session enter the respective locations or details of the sources

Vijay

• Oct 18th, 2006

Yes. It is possible having different Sources to load into the same target in a single session. But this again has a constraint on your requirement.  

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• Dec 12th, 2006

whether you are loading data from scratch(for the first time) or subsequent loads, there is no changes to the scheduling. The change is how to pickup the delta data.Hanu.

Answer Question  Select Best Answer

chinnu

• Feb 21st, 2007

Through Source Qualifier

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

Datawarehouse means it is the repository of integrated information in this OLTP part is there and OLAP part is also there E-R model it is the poor model and it is difficult to understand  and it ...

Answer Question  Select Best Answer

sravan

• Nov 4th, 2006

Target oad pan specifies the order in which the data being extracted from the source qualifier.

ram gopal

• Oct 24th, 2006

In a mapping if there are more than one target table,then we need to give in which order the target tables should be loadedexample: suppose in our mapping there are 2 target table 1. customer2. Audit ...

Answer Question  Select Best Answer

Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.but before I load into the target,I need to look-up some Dim ID,in this way,I must lookup twice.I think its not a good way.It's there another better?

kishore

• Nov 1st, 2006

Use session option truncate table.if you use this option whenever you start the session it will delete the target table records and then load the new records.

sats

• Nov 1st, 2006

well...u can use the option Truncate target in session(target properties)or use a truncate statement in pre-sql statement.either of the two should work fine..

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

Connected stored procedure will execute when each row passed through the mapping then it will execute, Unconnected stored procedure will execute when it is called by the another transformation, and connected stored procedure is the part of a data flow in a pipe line but unconnected is not.

Answer Question  Select Best Answer

I have a flat file as my source containing 100 records and i have two load this flat file data into two different targets .these two targets reside in two different sachems actually?

shaik

• Dec 20th, 2006

Yes u can load into different targets with different schema.First check source columns which matching to target table column and then load.

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 14th, 2007

ERP stands for Enterprise resource Planning for business developments and maintenance.Each and every database to store the organisation data is known as ERP.

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 9th, 2006

Its one kind of report. generally we will use this one in cognos

Answer Question  Select Best Answer

satya

• Nov 16th, 2006

 It is the ability to dynamically re-write SQL to the level of granularity neededto answer a business question

Answer Question  Select Best Answer

When we are extracting the data from excel sheet. at session level how can we set the database connection for excel sheet?

PooraniAshokkumar

• Nov 29th, 2006

hithis extraction of data can be done in another format alsowhat u can dou can copy the data from excel sheet to a notepad file then u can load the data in the source using import from flatfilethen in...

Answer Question  Select Best Answer