srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

I think this question is belongs to congnos.

Answer Question  Select Best Answer

Informatica_buddy

• Nov 10th, 2006

If you want single lookup values to be used in multiple target tables this can be done !!!For this we can  use Unconnected lookup and can collect the values from source table in any target table depending upon the business rule ...   

srinivas vadlakonda

• Oct 11th, 2006

just we can create the view by using two table then we can take that view as lookup table

Answer Question  Select Best Answer

informatica_buddy

• Nov 10th, 2006

You can actually create a view and import it as source in mapping ....

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

hifor database procedure we have procedure transmission. we can use that one.thanksmadhu

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

Neeraj

• Nov 7th, 2006

You can write the query as follows.SQL> select * from 2 (select ename,sal from emp order by sal desc) 3 where rownum

prasad

• Apr 27th, 2006

 the following is the query to find out the top three salariesin ORACLE:--(take emp table)select * from emp e where 3>(select count (*) from emp where e.sal>emp.sal) order by sal desc.in SQL Server:-(take emp table)select top 10 sal from emp

Answer Question  Select Best Answer

sivaprasad

• Nov 7th, 2006

in informatica7.11. we can take flatfile as a target 2.flatfile as lookup table3.dataprofiling&versioning4.union transformation.it works like union all.thanks &regardssivaprasad

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 6th, 2006

load manager is a manager who will take care about the loading process from source to target

Answer Question  Select Best Answer

MAni

• Nov 7th, 2006

Stop : After issuing stop PCS processes all those records which it got from source qualifier and writes to the target.Abort: It works in the same way as stop but there is a time out period of 60sec.

rkarthikeyan

• May 18th, 2006

Stop:We can Restart the sessionAbort:WE cant restart the session.We should truncate all the pipeline after that start the session

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

pallavi

• Nov 6th, 2006

Hi,Lookup is used to look into some other table to get the details for the related information of the current table. These tables have a common column and we get the related information if the condition satisfies.Pallavi

Shravan Gopisetty

• Sep 24th, 2006

We use Look up transfermations to implement the SCD to Implement the CDC(Change Data Capture).The following tasks can be implemented with look up transfermation.1.Get a Related value.2.SCD3.For calcul...

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

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

Acrien

• Nov 3rd, 2006

Informatica Sequence Generator:Maximum value reached at 2^(31) or 2.147 billion, and will automatically restart at 0. The sequence generator will calculate the max value in the column that you're add...

Answer Question  Select Best Answer

n k rajkumar

• Nov 2nd, 2006

User Defined Transformations Are Stored Procedure and Sourcr Qualifier 

Answer Question  Select Best Answer

Abhik

• Nov 1st, 2006

If the source is relational u can use DISTINCT option in SQ and if it flat file u can use sorter for this

gop

• Jun 14th, 2006

hi,how you seperate distinct value using filter, where you write no dictinct value. please make it more clear.

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

shiva

• Oct 30th, 2006

mostly we are geting oracle fatal error.whilw the server is not able to connect the oracle server.

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

If the join condition between the tables is wrong, you will get cartesian product.

Srinivas

• Aug 29th, 2006

Generate the SQL in SQ Transformation and try to run the same in TOAD.

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

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

Besides session log, it also creates the following files if applicable - reject files, target output file, incremental aggregation file, cache file

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Session Log file and Session Detail file

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