kusum

• Sep 27th, 2006

Whenever any source data is changed we need to capture it in the target system also this can be basically in 3 waysTarget record is completely replaced with new record(Type 1)Complete changes can be c...

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

CDC Changed Data Capture. Name itself saying that if any data is changed it will how to get the values. for this one we have type1 and type2 and type3 cdc's are there. depending upon our requirement we can fallow.thanksmadhu

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

SESSIONSession tells the server, how to fetch the metadata from repository for the specified mapping (data flow).TASK Task is a particular work that is for eg. Assignment Task is used to assign a value to the variable for the entire workflow.Still confusion then Wrtie me: nalla_ramsri @ yahoo . com

lingesh

• Oct 11th, 2006

Hi,    what is session?       When ever u create session it will ask for map which it has to link.For each seesion we can have one map to link with session...

Answer Question  Select Best Answer

channu

• Oct 3rd, 2006

Hi ....           I agree with u, can u explain me 3rd answer i.e to convert row to columns using Normalizer transformation.  plz

priya

• Sep 27th, 2006

1)Sequence generates only numeric values as sequence but not char or date whereas in other tools like OWB they can generate sequence of Date also2)Sometimes an element that occurs multiple times is a ...

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

Bulk mode is used for Oracle/SQLserver/Sybase.  This mode improves performance by not writing to the database log.  As a result, when using this mode recovery is unavailable.  Further, ...

srinivas vadlakonda

• Oct 11th, 2006

in case of bulk for group of records a dml statement will created and executedbut in the case of normal for every recorda a dml statement will created and executed if u selecting bulk performance will be increasing

Answer Question  Select Best Answer

Rajan Raorane

 Profile Answers by Rajan Raorane Questions by Rajan Raorane

• Oct 21st, 2010

No as Star Schema Includes combination Dimension table and fact table in which we already defined the Primary and foriegn key....Hence No ques of Duplicate Rows.

Ashwani

• Oct 25th, 2006

Duplicate row has nothing to do with StarSchema. StarSchema is mathodoly and Duplicate row is part of actual implementation in DB. If u look at Surrogate key conceot then "NO" beside surrogate key oth...

Answer Question  Select Best Answer

itjmn

 Profile Answers by itjmn Questions by itjmn

• Apr 12th, 2010

Chaning / altering the default querly generated by the following transformations is known a SQL Override.1. Source Qualifier Transformations2. Lookup3. Target

Vamsi Krishna.K

• Oct 1st, 2006

Hello,By default informatica server will generate sql query for every action, if that query is not able to perform the exact task, we can modify that query or we can genrate new once with new conditions and with new constraints.1. source qualifier2. lookup3. target

Answer Question  Select Best Answer

pradeeshkumar

 Profile Answers by pradeeshkumar Questions by pradeeshkumar

• Aug 19th, 2010

The frequency of loading data is based on the needs. It may be once in a week or at every nights.

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Loading frequency depends on the requirement of Business Users,  It could be daily during mid night... or weekly...  Depending on the frequency...  ETL process should take care... how t...

Answer Question  Select Best Answer

n k rajkumar

• Oct 18th, 2006

There are two types of target load typesthey are1. bulk2. normal

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

we define target load plans in 2 ways1. in mapping2. in session

Answer Question  Select Best Answer

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

Using flat files sql override willnot work. the extension of the flat files are .txt,.doc,.dat and the output or target flatfile extension is .out

Rajesh

• Oct 10th, 2006

In Flat file SQL Override will not work. We have different properties to set for a flat file. If you are talking about the flat file as a source it can be of any extension like .dat,.doc etc. Yes if i...

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 14th, 2010

SURROGATE KEY IS NOTHING BUT WHAT A PRIMARY KEY IS USED IN AN TRANSACTION DATABASE ,GENERALLY THIS COME IN PICTURE WHEN THE DATA IS UPDATING REGULARLY IN THE TABLE THIS MAKES THE TABLE INCONSISTENT SO...

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

Surrogate key or warehouse key acts like a composite primary key.  If the target doesn't have a unique key, the surrogate key helps to address a particular row.  It is like a primary key in the target.

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 9th, 2007

event based scheduling is using for row indicator file. when u dont no where is the source data that time we use shellcommand,script, batch file to send to the local directory of the informaticaserver is waiting for row indiactor file befor running the session.

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

In time based scheduling, the jobs run at the specified time.  In some situations, we've to run a job based on some events like if a file arrives then only the job has to run whatever the time it is.  In such cases, event based scheduling is used.  

Answer Question  Select Best Answer

pushpam

 Profile Answers by pushpam Questions by pushpam

• Nov 3rd, 2006

Toad is a application development tool built around an advanced SQL and PL/SQL editor. Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions. You can create and edit ...

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

TOAD is a user friendly interface for relational databases like Oracle, Sql Server, DB2.  While unit testing the development or query on tables, one can use TOAD with basic  knowledge on database commands.

Answer Question  Select Best Answer

sathishkumar_sundaram

 Profile Answers by sathishkumar_sundaram Questions by sathishkumar_sundaram

• Nov 6th, 2006

Hi,E-R model is Entity Relation model used in Two dimesional Databases.For Example, SQL Server, or Oracle. A table is based on two dimensions.Rows and Columns.Generally, OLTP systems are based on...

Arjun

• Nov 1st, 2006

This is Entity - Relation model which is used for normalising the data

Answer Question  Select Best Answer

tshah

 Profile Answers by tshah Questions by tshah

• Jun 6th, 2008

Unless the job is scheduled, you cannot manually run a workflow without using a GUI.

balaetl

 Profile Answers by balaetl Questions by balaetl

• Aug 3rd, 2007

Pmcmd is not GUI. It is a command you can use within unix script to run the workflow.

Answer Question  Select Best Answer

I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has...

superhero

 Profile Answers by superhero Questions by superhero

• Dec 8th, 2008

IIF(ISNULL(V-date),TO_DATE(SYSDATE, 'dd-mon-yy')IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Sep 13th, 2007

Simple use expression transformation and make all the inputs into the date format given. Add a condition like IIF(ISNULL(V-date),SYSDATE(),IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')This is my idea. It helps you hopefully....thx

Answer Question  Select Best Answer

shambhu

• Feb 25th, 2016

1. SQ is used to represent the data from sources (relational, flat file) which Integration service can read
2. Normalizer is used as a source qualifier when we have Cobol source (Denormalized), which SQ can not read
3. Normalizer can be used for transposing columns into rows

RSUDHAKARREDDI

 Profile Answers by RSUDHAKARREDDI Questions by RSUDHAKARREDDI

• Jun 20th, 2011

Source qualifier transformation extract data from only files and rdbms.but normaliser transformation used to extract data from COBOL files.

Answer Question  Select Best Answer

Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, u must select the Japanese code page of source data.

reshhhhhh

 Profile Answers by reshhhhhh Questions by reshhhhhh

• Sep 23rd, 2010

The code page influences the way the application stores, recieves and sends the data. Code page is basically to convert any language to the language that the system understands.

Answer Question  Select Best Answer

Two methods 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation. Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time. If u change the properties of a reusable transformation in...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

You can design using 2 methodsusing transformation developercreate normal one and promote it to reusable CheersSithu

Praveen Vasudev

• Sep 12th, 2005

PLEASE THINK TWICE BEFORE YOU POST AN ANSWER.Answer: Two methods 1.Design it in the transformation developer. by default its a reusable transform.2.Promote a standard transformation from the mapping d...

Answer Question  Select Best Answer

During the session ,the informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the informatica server replaces the stored row with the input row.The informatica server stores group information in an index cache and row data in a data cache.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Apr 11th, 2014

Rank caches are the caches created to calculate the rank while session run for Rank transformation. Index cache and Data cache Index cache stores the values of the key column i.e. rank port here. D...

Answer Question  Select Best Answer

Input group Output group The designer copies property information from the input ports of the input group to create a set of output ports for each output group. Two types of output groups User defined groups Default group U can not modify or delete default groups.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 23rd, 2006

A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output ports for...

phani

• Dec 9th, 2005

Input group contains the data which is coming from the source.We can create as many user-defined groups as required for each condition we want to specify.Default group contains all the rows of data that doesn't satisfy the condition of any group. 

Answer Question  Select Best Answer