Data Warehousing Community Forum
February 08, 2012, 10:04:16 am

  Show Posts
Pages: [1] 2 3 ... 6
1  Databases / Oracle / Difference between Varchar and Varchar2 on: June 28, 2011, 03:02:29 pm
Can you please differentiate between Varchar and Varchar2 ??
2  Databases / Oracle / Re: Difference between Truncate and Delete? on: June 22, 2011, 11:41:53 am
There is one more difference between these two -

TRUNCATE command resets the High Water Mark for the table but DELETE does not.
So TRUNCATE operations on table are much faster.
3  ETL Tools / Informatica / Re: Active & Passive Transformations..? on: June 22, 2011, 11:37:32 am
Java and Custom transformations can be created as active and passive transformations while you are creating them.

Where in you can't convert Active to Passive or Vice-versa once you have created them. Just to recreate them if it is required.
4  ETL Tools / Informatica / Re: Need Informatica Certification Dumps on: June 22, 2011, 11:34:38 am
Sipra,

Its been almost 2 long years from where in people are requesting. Too late response and kept on hold.  Angry

Pls post them as soon as possible. Thanks  Smiley
5  Databases / PL/SQL / Parameters in Explicit Cursors on: February 25, 2011, 01:19:54 am
Can we pass parameters to explicit cursors ??
6  Operating Systems / Unix Shell Scripting / Wrapper Script - elimination of first "n" records on: February 25, 2011, 01:18:48 am
I do a have a set of files and want to eliminate first "n" number of records and then to load those files to their respective tables.

I precisely mentioned "n" number of records because the elimination of first number of records is of different for the set of files
7  Data Warehousing / Data Warehousing Concepts / Re: Difference b/n Data Cleansing and Data Scrubbing? on: February 25, 2011, 01:16:35 am
In Data Cleansing, shall we take a step for preventing erroneous data.

Basically what are the different goals that will be achieved in Data Cleansing.
8  Databases / Teradata / Re: Teradata 10065 Error on: May 11, 2010, 09:27:44 pm
Check the services on your Machine...

This error will pop up during -
1) DB down
2) Netwrok is not confugured properly... (Real scenarios)

You saying, its on personal PC, so check your services. if they are down, bring them up... Cool
9  ETL Tools / Informatica / Re: Job Openings for Informatica on: May 11, 2010, 09:25:11 pm
Huge.... !

Celebration period for Data warehousing folks...  Kiss
10  General Category / General Discussion / Merry X-MAS and New Year 2010 Wishes on: December 28, 2009, 02:10:17 pm
Hi Buddy(s),

Wishing you and your Family

 

Happy go on... Smiley
11  General Category / Introductions / Re: Datawarehousing Tools on: December 28, 2009, 01:56:33 pm
Hey Rohit -

Firstly Welcome buddy...  Cool
Some information has been posted by Forumites already.. Have a look at this link

Hope this will do best for you...  Roll Eyes
12  ETL Tools / Informatica / Re: Mapping to seperate distinct and duplicate records on: December 28, 2009, 01:53:27 pm
Quote from: ankurgujral on December 25, 2009, 04:26:45 pm
I actually have a flat file which contains duplicate data and I want to seperate that data into a seperate file.

Ankur -  Wink
If you're working with Unix/Linux Systems, then removing duplicates from Flatfiles at source end is one of the best option (Scriptting).

If you want to do at Informatica level - Please wait around for sometime, i'll get back to you with layouts.  Cool
13  Databases / Oracle / Re: Oracle study material OCA on: December 23, 2009, 03:39:41 pm
Quote from: richa on December 22, 2009, 03:20:40 pm
Do you have any Orcale OCA certification material ? Please provide

Wrong section to post in...
Surely will post some OCA material - Have patience... Roll Eyes
14  ETL Tools / Informatica / Re: Mapping to seperate distinct and duplicate records on: December 23, 2009, 03:35:27 pm
Quote from: ankurgujral on December 22, 2009, 04:18:30 am
to seperate the distinct and duplicate records in seperate files.

Ankur -
Are you using source as Tables or Flatfiles. It can be achieved for of these in different scenario's...Huh
15  ETL Tools / Informatica / Re: Need Informatica Developer edition on: December 21, 2009, 01:02:10 pm
Quote from: amit5657 on July 10, 2008, 10:55:33 pm
  Can anyone tell me where to download Informatica V 8.5.1 developer edition ..

Amit - It's illegal to ask about the Softwares on a Live Forum.
See the below thread from Admin(s) -  Undecided

Quote
Informatica software
Pages: [1] 2 3 ... 6