Data Warehousing Community Forum
October 24, 2019, 01:20:57 am

  Show Posts
Pages: [1] 2 3 ... 24
1  Databases / Oracle / Re: REGEXP_REPLACE usage for complex strings on: September 29, 2015, 12:26:11 pm
regexp_replace (text, '<[^>]+>', '')

It describes a tag
the string signifies
a < sign, followed by 1 or more non > signs ([^>]+), followed by a > sign

So it will remove <BR>, <HTML>, etc.,
The caret inside [] means negation and + sign means one or more.
2  Data Warehousing / Data Warehousing Concepts / Re: Running sessions concurrently and simultaneously!! on: September 29, 2015, 12:16:21 pm
Which ETL tool you are using to run the sessions - Informatica ??
3  ETL Tools / Informatica / Re: How to send Bad file records to a client. on: September 29, 2015, 12:13:03 pm

your rejected records will be written in bad file or reject file which will be located either on your Windows or Unix directory.
After completion of the said workflow, you can use post session command, where in you can send the complete file to any desired email.

Hope this answers.
4  General Category / General Discussion / Re: require suggestion on suitable tool on: September 29, 2015, 12:10:06 pm

With 9 years of enormous experience in mainframes & DB2, why you want to shift the career ?
If you still want to take up the decision, in Informatica ETL tool, the source data will be retrieved from mainframe files (exclusively some clients)

You can enrich your knowledge on Informatica ETL tool.
5  General Category / Suggestions / Re: Other categories on: September 29, 2015, 12:05:16 pm
Thanks Phil for your valuable suggestion.

But seeing the other way, people will post the queries in only those respective areas as we expect only newbies to the forum always. They will be hurry and with that will create a mess.

Anyhow we look forward your suggestion and discuss with Other Moderators. Thanks for the Suggestion.. Smiley
6  ETL Tools / Informatica / Re: Delete Source View in Informatica Designer on: November 06, 2013, 10:12:08 am
How to delete the source view from informatica designer??
If you are using versioning repository then you check out that object for deletion or else you can directly delete the view.
Anyhow how you have created source view & where it is ?
7  Data Warehousing / Data Warehousing Concepts / Re: Need Good Document for Informatica on: November 01, 2013, 01:50:10 pm
I have seen some of the posts in this forum. It's very nice and more help full for all who work on informatica.
Thanks Ramakrishna for your appreciations on the Forum.
I would like request if any body has good document for informatica. Please share in this forum or Please provide the URL.

For a DW Fresher or Informatica Fresher, You have to go thru first basics. Study guide Help guides you what you have to go thru first. Have a look. Any questions, revert back Ramkrishna. Wink
8  Data Warehousing / Data Warehousing Concepts / Re: Configuration for Datawarehousing on: November 01, 2013, 01:41:16 pm
It's the first time for me to write on this forum and i hope i'll find answers to my questions.

Firstly welcoming you to the forum.
I'm doing some research on real-time datawarehousing. i tried to configure one RT dw but i'm not sure that every things are ok.
i have an operational data source which is in oracle. and i've created new schema in the same database and consider it as the DW (is it correct what i did?). i'm using OWB as ETL and i've designed a simple map that extract data from two table, do light transformation and insert them into the target table (in the let's say DW).
My question is: Is this configuration right ftosay i'm working on a datawarehouse?
You are doing obviously going in a right direction. What kind of any help do you require. Pls keep posting.
9  ETL Tools / Informatica / Re: Expression - IFF and IS NULL on: November 01, 2013, 01:33:57 pm
The expression also you can write like this


10  General Category / General Discussion / Happy Diwali - DW Forumites on: November 01, 2013, 01:20:13 pm

May millions of Lamps illuminate ur life with endless joy, prosperity, health & wealth forever.
Our entire team at DW Forum takes immense pleasure in wishing you a Very Happy and Festive
11  ETL Tools / Informatica / Re: Decimal data type appending zeroes for whole numbers as well-default behaviour? on: October 23, 2013, 07:29:48 pm
I meant not to strip the trailing zeros after the decimal places in the field values and only display when there is atleast a significant figure after two places to decimal.
Dear Abhishek,
First and foremost, if your source and target table have same datatype, then the data will be loading very similar to that of source unless you have done some transformations.

From the expression validator I always get field values in the format KPQ.YJ (where Y & J are not both zeroes and there can be any number of non zero digits before decimal) or ABCD. I want the xml to have KPQ.YJ in first case and ABCD in second case however ABCD is getting populated as ABCD.00 because of the traget data type.
As per your sayings above, if the source data is like 1234.56 then the target data should load the same i.e., 1234.56 and the data is 9876.00 then the data should be loaded as 9876. Here a correction,as your target table is having the decimal values, so your data will be visibly 9876.00. There's no mistake in it and it will do the same.
12  ETL Tools / Installation & Configuration / Re: Informatica 9.0 Download on: October 22, 2013, 04:25:26 pm
Dear Raj,

For your information, Informatica is not an open source tool to get it for free.You need to purchase which is very expensive or if your employer is in partnership with Informatica, you will be getting it for free for internal trainings and self learning.
13  ETL Tools / Informatica / Re: Need Informatica Certification Dumps on: October 22, 2013, 04:08:10 pm
Thanks a lot Sipra for sharing  Smiley
All Folks , would be very helpful if you share your experience if you have used / going to use these dumps for ICS DI PowerCenter Dev 9x exam.
You are welcome Sami.

Pls do share information so that we can spread across each and every DW folks
14  ETL Tools / Informatica / Re: Need Informatica Certification Dumps on: October 21, 2013, 10:11:01 pm
Here you have Informatica 9.0 certification dumps.

P.S :Need to login to download the attached file - Informatica_9.0_Certification_Dumps.pdf
15  ETL Tools / Informatica / Re: Need Suggestions to reduce load time during Business hours on: October 21, 2013, 10:07:48 am
Performance tuning is the smartest work that should be done initially at the time of preparing your complete Data warehouse. But this never happens in IT field because developer finishes his work and delivers into production in a hurry of deliverable timelines. Later this will be carried out by Production support teams, whom will be having very minute knowledge on business functionality.
Reality is what unknown said. Accepted.
Will try to provide a relevant document on this very soon. Pls be awaited.
Pls post it in pdf file.
Pages: [1] 2 3 ... 24